By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Error importing Excel data into Access...

P: n/a
I have worked very little with Access and have hit a snag.

My task right now is to import the data from a spreadsheet into an
existing table in an Access database. I edited the .xls file so that
fields are laid out the same L-R and made certain that the data is the
same in both the .xls file and the table it is to be imported to have
the same data type in each field.

I follow the File>Get External Data>Import path and choose the .xls
file I want to import, select the correct worksheet, check the box to
make sure the first row is read as column headings, select the
existing table it is to be imported to, and get an error message each
time:

'An error occured while trying to import the file: "(file name)". File
could nto be imported'.

I've also tried importing it into a new table, which works; but when I
try to import the data from the new table into the existing table I
get the same error.

This .xls file has some 3000 rows in it and each needs to be a record
in this table. Is there any way short of manually keying in the data
that I can make it work. I'm certain there must be a way and my
limited knowledge of Access is preventing me from finding it.

Many Thanks,
Jeremy

Feb 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Feb 6, 12:47 pm, "puremeta...@gmail.com" <puremeta...@gmail.com>
wrote:
I have worked very little with Access and have hit a snag.

My task right now is to import the data from a spreadsheet into an
existing table in an Access database. I edited the .xls file so that
fields are laid out the same L-R and made certain that the data is the
same in both the .xls file and the table it is to be imported to have
the same data type in each field.

I follow the File>Get External Data>Import path and choose the .xls
file I want to import, select the correct worksheet, check the box to
make sure the first row is read as column headings, select the
existing table it is to be imported to, and get an error message each
time:

'An error occured while trying to import the file: "(file name)". File
could nto be imported'.

I've also tried importing it into a new table, which works; but when I
try to import the data from the new table into the existing table I
get the same error.

This .xls file has some 3000 rows in it and each needs to be a record
in this table. Is there any way short of manually keying in the data
that I can make it work. I'm certain there must be a way and my
limited knowledge of Access is preventing me from finding it.

Many Thanks,
Jeremy
One other thing, I attempted to save the .xls file in both .csv
and .txt format and got the same result - the import error. Comma
delimited came closest to working, but it didn't like the field names
in the .csv file and errored out as a result.

Feb 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.