Importing to Access from Excel

  • Thread starter Thread starter beth
  • Start date Start date
B

beth

I desperately need to be able to enter data into Excel
then later add it to my existing customer database. I
have followed the directions exactly per a book called
Step by Step Microsoft Access 2002, but keep getting an
error message -- which gives no clue why it won't import.
I am copying/pasting the column headings directly from the
existing Access table to an Excel worksheet, so the
headings match exactly in size, words, etc. Any advice on
where to look for help. This shouldn't be so hard, should
it? Also, if the information (basically name, address,
phone, email) ever does import, what will happen with my
CustomersID column -- as of now, when I enter a customer
in Access, it automatically assigns him a number. The
problem with all Microsoft products is finding somewhere
to get help without paying megabucks. Any input is
appreciated.
 
-----Original Message-----
I desperately need to be able to enter data into Excel
then later add it to my existing customer database. I
have followed the directions exactly per a book called
Step by Step Microsoft Access 2002, but keep getting an
error message -- which gives no clue why it won't import.
I am copying/pasting the column headings directly from the
existing Access table to an Excel worksheet, so the
headings match exactly in size, words, etc. Any advice on
where to look for help. This shouldn't be so hard, should
it? Also, if the information (basically name, address,
phone, email) ever does import, what will happen with my
CustomersID column -- as of now, when I enter a customer
in Access, it automatically assigns him a number. The
problem with all Microsoft products is finding somewhere
to get help without paying megabucks. Any input is
appreciated.
.
Click to expand...

Sorry you're having trouble. No; I don't think it should
be difficult either. I can think of these possibilities:

- Field Type Conflict, i.e., Access is trying to import
what it thinks is a number from the Excel sheet into a
Text field, or vice versa. Try importing the sheet into a
new table, and check the data types vs. your existing
table.

- You are specifying a spreadsheet range name that does
not have the same number of columns as your target table.

In either case, import the data to a new table, and use an
append query to insert the new records. Access will
assign a primary key value.

HTH
Kevin Sprinkel
Becker & Frondorf
 
The first row of Excel data determines the formatting of
the table. Make sure the the first row of data in your
Excel worksheet contains data in every field. What I like
to do is to have a dummy 1st row of data with the proper
formats and delete a fter import.

Good luck

Jim
 
Back
Top