Access Import CSV

[Arthur Jelsma]

When I try to import into an Access database from a csv
file I get the message "You entered an expression that
has an invalid reference to the property |". Another
individual using the same database and csv file is able
to import the data with no problems. Any ideas as to what
might be happening? Thanks for any help. I am using
Access 2002 on a Windows 2000 platform.

 

[Ken Snell]

When you say another individual can import the file "using the same database
and csv file", do you mean the same database on the same PC? or on a
different PC?

Try copying that database from the other PC onto yours and try it. Your copy
may be corrupted.

 

[Arthur Jelsma]

What I mean is that another individual on a different PC
copied the same csv file to his machine as I did. He
copied the same empty database to his machine as I did.
He tried to populate the database using Import of External
Data from the csv file and was successful.

I had him send me his populated database, a copy of his
empty database, and his csv file. I was able to open his
database and see the data. I then tried to populate the
empty database from the csv file and got the same error.

I resorted to reinstalling Office after uninstalling it
and I got the same error.

I also checked the options on his machine against mine and
confirmed that we had the same settings.

It seems to me that there must be a setting, i.e. registry.
That did not get deleted in the uninstall.

 

[Ken Snell]

It may be that your References are messed up.

From info posted previously by Douglas Steele:

Your references are probably messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html