External Data
Posted by David Dorsey on September 20, 2000 7:22 AM
Our parent company has supplied an Excel spreadsheet to be used as a template for purchase orders. It is basically a fill-in-the-blank type approach. Our accounting software requires us to enter purchase orders there, as well. Accounts payable is suffering in "Duplicate Entry Hell"!
I have ODBC access to the accounting files, and have used MS Access to extract the PO data that is needed in the spreadsheet. I do NOT, however, have any idea on how to export/import the data into Excel so that the fields required will be inserted into the proper cells in the spreadsheet. All I need is the data in text form. The spreadsheet will be emailed to the home office to be processed, and self updating links, etc., won't work.
Any ideas would be most appreciated. Should, however, any of your IM force be caught or killed, my secretary will still take a two hour lunch break ...
Regards,
David
Posted by Thomas Venn on September 25, 2000 9:39 AM
You could try recording a macro for this. first, you need to import the data into excel as a seperate worksheet, then extract the data from that worksheet into your template. if you AP data has specific fields with names, the process is easier, because you can tell the macro where to go based on the specific name, then return that value to the template. mess around with the record macro function. good luck, jim...
