Import Excel data into Access

[Johneeo]

I have an Excel spreadsheet with data.

I want to import this data into Access. The Excel field names are identical to the Access field names, so I want the data to be added to an existing table exactly, field matching field.

Details on how to do this would be greatly appreciated.

Thanx

johneeo@rcn.com

 

[Darrylles]

Hiya,

File -> Import, change 'Files of Type' to Excel, locate the spreadsheet -> open it and follow the Wizard instructions.

p.s. Make sure that the data-types in your newly created table are correct to avoid errors.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Darrylles]

p.p.s

You don't really need to create the Access table first - Access will use the Excel column headings as fieldnames.
It does however assume the data-type of the field from the first 'data' cell from each column - so if you have '123' in the first cell of a 'text' column - that field will be typed as numeric.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Garridon]

I'd recommend you import into in a new table. That helps if you have any problems, like data normalization (i.e., phone numbers written different ways) or errors in the import. Then, once you've checked over the data, create an append query and append them into the table you really want the data to go.

Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com