MS Access Database with External Data - Importing data resulting in a query failing to work

Author

Importing data resulting in a query failing to work

Chris W via AccessMonster.com

2005-09-28, 3:25 am

Hi

I am trying to import data to two separate tables that are linked in a one to
my relationship. I am doing this by files-get external data-Import. I have
managed to get the import to work fine, no deleted records because of any
filed violations or primary key errors. However after I have done all this, a
query that is based on these two tables, does not return any results. I have
experimented by importing only a small number of records, and manually
imputing the exact same records and the query works fine when the data has
been manually inserted.

Thank you in advance for any help it is very much appreciated.

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...aldata/200509/1

Luke Middleton via AccessMonster.com

2005-09-29, 8:25 pm

Chris,

Can you post the query that is giving you the problem? I wonder if it uses
wildcards at all? (such as * or %)

I have had a similar problem which I have not yet heard of anyone else
encountering. It seems that some imports can have the effect of changing the
ANSI SQL query mode from ANSI 92 to 89, at least as it concerns controls on a
form. The issue was never resolved, but you can read about it here -
http://groups.google.com/group/micr...de8ad39e7874c59

Don't know if that has anything to do with your problem or not, but just
thought I'd throw it out. Would be interesting if someone else came across it.
...

Luke

Sponsored Links