Import excel file...

[btj]

When I initially established my database, I had to import from excel. After some work, I was successful although I had to put the data into a new "temporary" table and then copy over to the primary table.

Now, I find that my users will occassionally want to import data into a table from Excel. I have been playing around with the possibility but have found no good method. My primary issue is that the data has to be very formatted (i.e. look identical to my table) in order to transfer the data to an existing table. Otherwise, Access will only let me import to a new table.

Although it would be a pain for me, it seems that it might be quicker to manually input the data (when needed) than to try to work on some complex Excel import.

Does anyone have any suggestions on this issue? I would appreciate any advice that you may have.

Thank you, in advance.

-Ben

 

[PaulaJ]

When I need to import from Excel, I do the following: Remove all Titles, and make sure there is only one line of headings. The headings will be the field names and unless they match exactly, you cannot import to the same file twice. Then Save as a .csv file. You may have to save each worksheet separately. Open Access and Import to a New Table the first time, as Delimited, Comma, First Row Contains Field Names. Key as Desired and Finish. After this first time, if all of the field names match exactly, you should be able to import to an existing table. The .csv establishes the data in positional order, so unless some cells are out of position in the spreadsheet, it should import OK for you.