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

Excel File Import Error

P: n/a
Trying to import a couple of fields from an excel spreadsheet into an
Access 2000 database by extracting needed fields and pasting them into
a new spreadsheet, I can import the data into a new table in the
database but will not allow me to import the same spreadsheet into an
existing table w/ the same field properties. I know there's nothing
wrong w/ the data because again it will allow me to import and create
a new table w/ data, just cannot populate into the already existing
table. The only error message given is that file was not imported,
but does not say why in the error message. Has anyone come across
this and found a solution...thanks
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Shot in the dark, but do you have a PK in the table in Access? if
it's not autonumber and you're trying to import duplicate records (as
far as the PK is concerned), it will fail.
Nov 13 '05 #2

P: n/a
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
Shot in the dark, but do you have a PK in the table in Access? if
it's not autonumber and you're trying to import duplicate records (as
far as the PK is concerned), it will fail.


tried both, one of the fields is reference number so used that field
as pk, also tried using autonumber as primery key...
Nov 13 '05 #3

P: n/a
da*****@mindspring.com (Danny) wrote in message news:<35**************************@posting.google. com>...
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
Shot in the dark, but do you have a PK in the table in Access? if
it's not autonumber and you're trying to import duplicate records (as
far as the PK is concerned), it will fail.


tried both, one of the fields is reference number so used that field
as pk, also tried using autonumber as primery key...


what fields are indexed in your table? Are there any unique indices?
Remove the uniqueness constraints and see if it works.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.