please can anyone help

[itsglitzy]

its a long shot....im trying to import data from a 600mb text file into access

the text file has had its headers removed..

so i have created a new table with the same column headers but when i try to import the text file to the table created

i keep getting "invalid argument" I cant see any probs...

many thx in advance to all who post

I have tried it again and got

"Records could not be added to the exceptions table"

 

[M8KWR]

have you tried linking to the text file instead, and seeing if you are able to open it up then.

If you are able to do it this way then create a query to make a new table from the linked text file.

I hope this makes sense, any more issue please let me know.

 

[itsglitzy]

hi thnx for your reply, seems like a good idea, i manged to link the table but when i try to run a delete query it wont let same result, i also tried to create a new table and the appent the linked table to it but this didnt work either....any other ideas..?

 

[M8KWR]

can you open the file up in excel!!!!! and convert to to a xls file instead!!!

Since the file is so large i'm unsure if this would be possible though.

I would say send me the excel file, but again this would be an issue due to the size.

So you can link it, can you actually open the table!! If so once access has loaded all the data, copy this, open up the table that you create, and paste the records in, this would take some time , if it works.

Let me know how you get on.

 

[M8KWR]

another idea, where did this text file come from, could you go back and get it in another format, or the text file may be corrupt!!!!

 

[itsglitzy]

when i try to open it in excel, excel hangs, the text file came from a data warehouse, if i tried to generate the text file again but in smaller bits and then export it in would that work ??

 

[M8KWR]

if you can do it in smaller files then this would be better.

What i would do is to try a 20-50mb file first and to make sure this imports, then try a 100mb file. It may be the size of the text file, or some data that due being a text file it has corrupted it some how.

Have you tried linking directly into your data warehouse!!!!!