invalid argument

[jskamm]

Can anyone help? Running the following query:
INSERT INTO ildonotcalltable12_8_08 ( phonenumber )
SELECT ac & phone AS phonenumber
FROM [TEXT;DATABASE=C:\Do Not Call List\].IL_12_8_2008_do_not_call_list.txt;
I have a database with ac and phonenumber(2 million records) in seperate
columns in a text file. I need to put ac and phonenumber in one column in
access, and then use that new access table to find duplicate phonenumber in
another table. This query used to work but now I'm getting Invalid Argument
error message. Can anyone tell what to do to get this to work.
Thanks

 

[John W. Vinson]

Can anyone help? Running the following query:
INSERT INTO ildonotcalltable12_8_08 ( phonenumber )
SELECT ac & phone AS phonenumber
FROM [TEXT;DATABASE=C:\Do Not Call List\].IL_12_8_2008_do_not_call_list.txt;
I have a database with ac and phonenumber(2 million records) in seperate
columns in a text file. I need to put ac and phonenumber in one column in
access, and then use that new access table to find duplicate phonenumber in
another table. This query used to work but now I'm getting Invalid Argument
error message. Can anyone tell what to do to get this to work.
Thanks

What's the datatype and size of phonenumber? How big is your .mdb file -
you're not pushing the 2GByte limit, are you? Does Compacting the database
help?

 

[jskamm]

Thanks for your info. Got it to work. Looks like there was a size issue. My
..mdb file was over 2GB's. Just created a new database and now the query
works.

Can anyone help? Running the following query:
INSERT INTO ildonotcalltable12_8_08 ( phonenumber )
SELECT ac & phone AS phonenumber
FROM [TEXT;DATABASE=C:\Do Not Call List\].IL_12_8_2008_do_not_call_list.txt;
I have a database with ac and phonenumber(2 million records) in seperate
columns in a text file. I need to put ac and phonenumber in one column in
access, and then use that new access table to find duplicate phonenumber in
another table. This query used to work but now I'm getting Invalid Argument
error message. Can anyone tell what to do to get this to work.
Thanks

What's the datatype and size of phonenumber? How big is your .mdb file -
you're not pushing the 2GByte limit, are you? Does Compacting the database
help?

 

[John W. Vinson]

Thanks for your info. Got it to work. Looks like there was a size issue. My
.mdb file was over 2GB's. Just created a new database and now the query
works.

You'll need to Compact the database whenever you run this procedure (I'd
suggest before and after just to be safe), and monitor the size. You'll get
all sorts of peculiar and uninformative errors - like this one - if you hit
the 2GByte limit.