Import information from Excel

[Stockwell43]

Hello,

I was wondering if it was possible to import from excel? I have exported
from a report but never imported. If this can be done, can someone point in
the right direction? In otherwords, do I need the same fields in access as
excel and named exactly the same and so forth?

Thanks!!

 

[akphidelt]

The names of the columns don't matter... but data formats do. It's pretty
simple... open access, go to Import, change file type to Excel. Select the
file and follow the wizard.

 

[Ron2006]

If doing this more than once.

Check Transferspreadsheet
Import is one of the options.

If into a new table the column headings will become the field names so
nothing is required until you want to use the information elsewhere in
which case you obviously need to know the field names.

If into existing table then
1) run a query to empty the table first
2) then do the transferspreadsheet.
3) field names MUST match 100 percent (at least NO NEW fields or data
in columns with no headings unless it is always that way in which case
it will become FIELD##)
4) Watch out for a field that may have numeric data in the first few
rows and then changes to alpha, this can cause a problem.


Ron

 

[Stockwell43]

Hi akphidelt,

Thank you! I didn't realize it was that easy!!!

 

[lunwanting]

If doing this more than once.

Check Transferspreadsheet
Import is one of the options.

If into a new table the column headings will become the field names so
nothing is required until you want to use the information elsewhere in
which case you obviously need to know the field names.

If into existing table then
1) run a query to empty the table first
2) then do the transferspreadsheet.
3) field names MUST match 100 percent (at least NO NEW fields or data
in columns with no headings unless it is always that way in which case
it will become FIELD##)
4) Watch out for a field that may have numeric data in the first few
rows and then changes to alpha, this can cause a problem.


Ron

 

[jackson]

??