Import multiple excel files into single access table

[HGMonaro]

dS, if you want to capture that 1st row of data, change your import specification so that it doesn't expect fieldnames (not sure if you've done that). If that imports ok then do the following:

in the loop retrieving the files in the folder:
- Use a delete query to empty the import table
- Import the file into this table using the import spec
- Use a query to add the date (maybe into another tempory table using a Make Table Query)
- Append this table to another table that will hold all the data

something like that! Just tried the import part and it worked fine (1st row is in data)

 

[Morrel]

I have a problem:

I want to import data from multiple excel sheets into 1 table in my database. The problem is that the excel sheets allready have a connection to another database for various data. The excel sheets are merely for making calculations.

So when i change data in the database it should change in the Excel file but it should change in the other database as well without having to open al the excel sheets.

To sum up the problem.

• I need a solution that can:
• Automatic change data from a database to multiple excel sheets to one other database. this without opening all of the excel files.
• Each excel file should be considered as one record in the new database
• This should happen by using a save button in the excel file

I really suck at programming but if someone could give me a clue how to do this you would be very welcome