Access 2003 - An error occurred trying to import file

[forbsy]

Hi. How does one import several worksheets into an access database table? I successfully imported the first worksheet into an access table just fine. When I attempted to import an additional worksheet (from the same workbook) into the existing access table, I received the error, 'An error occurred trying to import file '{file.xls}'. The file was not imported.
The worksheets are all formatted identically, with different data. Does anyone know what I might be doing incorrectly?

Thanks

 

[fneily]

First, Access questions should be posted in the Access forums.

Start with a close excel file. Open Access and the database you want the data to be in. Click on File, Get External Data, Import. Select the Excel File. You will get a window asking for which sheet in the file to import into a new table. Repeat for each sheet.

IMPORTANT: If you are importing Excel worksheets into an Access table, YOU MUST NORMALIZE. That means one worksheet may create two, three, or more tables. If you are not Normalizing, YOU ARE USING ACCESS WRONG. Access tables are NOT spreadsheets. It is a RELATIONAL database and follows exact rules for table creation. I see this in major companies when I do contract work and IT IS WRONG.

 

[forbsy]

Hi. Thanks for the respone. I had already performed the steps you outlined. The first worksheet imported correctly. It was the additional worksheets that started giving me the error.
I'm afraid I don't understand what you mean by NORMALIZE.

Thanks