Text file import

[Kevin Spencer]

Hi Guys,

I need to import a large CSV file into Access, but when I try to I receive
the following error message:

"Bad file name or number"

I know the file is OK, so I am presuming it is the size.

Can anyone help?

Thanks

Kevin

 

[Ken Snell [MVP]]

You could open the text file in code and write it into a recordset bound to
a table. But, before we go there, is the path to the text file a long one?
How did you try to import?

 

[Kevin Spencer]

Hi Ken

The text file is on my desktop, I went to get external data -> Import. I
then chose thr file type as text file and then clicked on OK, Access has a
think about it for a couple of seconds and then produces the error.

Thanks

Kevin

 

[Joseph Meehan]

Hi Guys,

I need to import a large CSV file into Access, but when I try to I
receive the following error message:

"Bad file name or number"

I know the file is OK, so I am presuming it is the size.

Can anyone help?

Thanks

Kevin

Could you give is the exact name of the file. As I recall access does
not like some non-alpha characters in names.

 

[Ken Snell [MVP]]

What is the path to the file?

 

[Ken Snell [MVP]]

And how big is the text file (megabytes?)?

 

[Kevin Spencer]

C:\Documents and Settings\kevin\Desktop\

What is the path to the file?

 

[Kevin Spencer]

I know this is where I get told off, but it is 4 Gb

 

[Kevin Spencer]

The file does have an underscore in it!

Could you give is the exact name of the file. As I recall access does
not like some non-alpha characters in names.

 

[Guest]

yep Access has a 2 Gigabyte limit.

I know this is where I get told off, but it is 4 Gb

 

[Kevin Spencer]

Thanks Karl, I had that feeling! I was trying to avoid using SQL, but there
you go


Kevin

 

[Ken Snell [MVP]]

<g > Nah, I wouldn't "tell you off", but as noted elsethread, the amount of
data is going to exceed what one file in ACCESS can hold.

It might be doable to break the text file into separate, smaller sizes and
import them into separate ACCESS databases. You then could link to all the
databases for doing searching, etc. or whatever you want to do with the
data. Might make the queries a bit more complex, but may serve your purpose.

 

[Joseph Meehan]

The file does have an underscore in it!

I think that will do it. You may need to change the name of the file.