Text file import

K

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
 
K

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?
 
K

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
 
K

Kevin Spencer

The file does have an underscore in it!


Joseph Meehan said:
Could you give is the exact name of the file. As I recall access does
not like some non-alpha characters in names.
Click to expand...
 
K

Kevin Spencer

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


Kevin
 
K

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