![]() ![]() Go to Data tab and select From Other Sources as shown in the screen shot below. I repointed the integration to the new Excel sheet and it worked perfectly. This article will help users to embed SQL Query in Excel 2010 and create a dynamic connection in Excel. This let me write a simple, SQL-like “Select * from blah blah blah” to filter the data into a new Excel sheet. I dreaded writing some kind of array formula to make it happen and then I remembered ODBC.Īs a test, I used Excel’s ODBC functionality to look back into the sheet of the same workbook I was in. So how was I going to filter out just the populated lines? I would have to do it in Excel. Below the headers were detail lines that corresponded to the headers. These were fixed and populated by data from another excel tab. The spreadsheet source had 20 rows of headers, one for each potential company, but most of them were blank. ![]() We’d had some problems with filtering incoming data with this version of SmartConnect. We were integrating from SmartConnect to GP using Excel as the source. Over the last couple of weeks we’ve looked at some SmartConnect/Excel integration items for Dynamics GP. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |