Importing data resulting in a query failing to work

  • Thread starter Thread starter Chris W via AccessMonster.com
  • Start date Start date
C

Chris W via AccessMonster.com

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.
 
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...read/thread/b6108fb50718e605/bde8ad39e7874c59


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
 
Back
Top