Excel Import - New User

[schafle]

Help Please.

I am new to Access. I want to import a lot of sales detail into access for further reporting and analysis. When I import external data, everything appears to go fine but I can not seem to find the the imported data in a database. Can you point me in the right direction. Thanks

 

[Andrew Fergus]

Hi,

Part of the import process asks you to specifiy whether the data is saved in a new table or an existing table. If you save it in a new table it then asks for the table name - the name usually defaults to something like "Sheet 1" unless you change it. I suggest you look at your tables (Menu, View, Database Objects, Tables) and you may find "Sheet 1" or something similar there.

If you imported the data into an existing table then you should find the data within the table you specified at that time (Menu, View, Database Objects, Tables, double click the table to open it).

If there were any issues with the import process then you will often see a table with a heading like "Import Errors" or something similar. This will show the row number and the issue with the imported data.

Hope this helps, Andrew.

 

[Smitty]

Are you trying to append to an existing table or start a new one? If you're appending, you may not see your newly added data unless you go to the end record and look up from there. If I don't have a stable setup, I like to import a new table before I integrate it with existing info, just so I don't FUBAR myself.

File-->Get External Data-->Import or Link usually works fine.

The hardest part about Access is getting things set up the right way; after that it's generally a breeze.

For more than that, you'd have to be more specific...

HTH,

Smitty