Hi, I'm really hoping someone could help guide me in coding this.
I have many invoices coming from various companies. I would like to merge all of the invoices by extracting selected information, & adding fields that would explain company name and invoice period.
After doing a lot of research, I've come up with a different importing approach.
Here's the new idea folks:
1. Run a TransferSpreadsheet using acLink to link to the spreadsheet/csv file.
2. Run an Append query to append the records from the linked table to the merged invoice table. Run queries: add fields, extract fields from invoice, etc.
3. Delete the link to the spreadsheet/csv file.
I read somewhere that this reduces bloating of your db, if you link the tables and then delete them.
I just need to know how
a) temporary link tables
b) extract and add information I need
c) merge the data to a table in my db