Importing excel files into an access table PLEASE HelpVery desprate!!!

[outhere]

I really have to know how to import all my excel documents into an access table as well!!! please by tonight, I cant leave the office until its done !!!

I can import one excel sheet no prob, but when I go to import the next, though it has all the same amount of feilds into that same table I get an error message....

WTF Ive been trying different ways for hours now!!

Desprate beyond belief....
Steve

 

[JVFriederick]

Can you import each sheet into it's own table, then combine the tables?

My Access knowledge is limited, and unfortunately I don't have Access here at home...........

 

[SHardy]

Presumably you are importing into Access by using range names that are setup within the spreadsheet?

What is the error message that you are getting?

Of course, when pushed for time, you can always try the old fashioned cut and paste. The only errors you should encounter then are any possible data mismatches between the two apps.

 

[mattpearcey]

Do you still need help with this?

If the data is all the same, but in different excel spreadsheets, then your best idea is to crop all the data into one spreadsheet. Then go to Get External Data and import from file. Then you must create new tables from the spreadsheet, and dont makethe tables up first. I have had this problem before and had to do it this way. It will work, just follow te wizards where poss.

Hope you made it out of the office! Thank you for your help already.

Matt Pearcey