importing excel data

  • Thread starter Thread starter msdobe
  • Start date Start date
M

msdobe

I have and excel spreadsheet I'd like to import into an existing access
database. It includes: first name, last name, address,.... a total of 12
fields. I've read the tutorials and the forums, but I'm still stuck as how to
do this.

This is what I've done and I keep getting an error:
File, open excel spreadsheet, click first row column and headings, then I
get the error.
I'm totally stumped and don't know where to begin.
Any help would really be appreciated!

Thank you.
Jenny
 
I have and excel spreadsheet I'd like to import into an existing access
database. It includes: first name, last name, address,.... a total of 12
fields. I've read the tutorials and the forums, but I'm still stuck as how to
do this.  

This is what I've done and I keep getting an error:
File, open excel spreadsheet, click first row column and headings, then I
get the error.
I'm totally stumped and don't know where to begin.
Any help would really be appreciated!

Thank you.
Jenny
Click to expand...

Nothing to it.
In Access, choose File, Get External Data. The default type is "MDB
(Access)" Change it to Excel. Then select your file. Then click
OK. The wizard should run asking you to either import into an
existing table (if you do that, you have to map the columns in your
spreadsheet to fields/columns in your database table), or create a new
table.
If you choose a new one, you need to select a unieuq
 
I did that, but I keep coming up with an error - 'the file was not imported'.
You said I have to "map the columns in my spreadsheet to the fields in my
database". All the fields are the same heading, if that's what you meant.
Jenny
 
Back
Top