Originally Posted by Guus2005
Very irritating large font.
Import each spreadsheet in its own temporary table. Use an insert query to move records from the temporary table to the final table. Delete the temporary table.
Output what you need.
Sorry about the font?
I was looking for help with the code... I want this automated. non computer savy people will be using the program.
So how do I write code for this:
a) I would like Access to search the folders for the Excel files in the same FOLDER/DIR. that the Access file resides in. - For example: if I put the Access file and the 3 Excel files in a folder called “c:\windows\test\myname” or any folder I wish – Then Access would start its search for the Excel files at that location or any folder I put the Access file in.
How do I automate this:
2) I don’t even know if this is possible but... is there a way to build relationships (linking tables together) using VB? – I need this for my query to run/execute.
Thanks for your help!