I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company?
Any recomended procedure to pull this data to the table?
Thanks for all responses!
Need a little more detail. Where is the table you want to update daily? In another app, in Access, in Excel, in SQL.
I was planning to create an external table that would be used to store the AR invoices for the day. I would then pull the invoices to an oracle database where it would be consumed. The final destination requires a text file for import. I've considered a linked table or creating a stored procedure in the SQL Server database to pull the invoices and load the table.
So the table would likely be in SQL, but all options are on the table.
I hope that makes sense.