importing large CSV file into Access

  • Thread starter Thread starter PB
  • Start date Start date
P

PB

I have a large csv file that i am trying to get into
Access. The problem is that when i import it only the
first 33 of the 105 columns actually go in. Any ideas
would be much appreciated. Thanks!
 
Can you give us more info? What are the data like? How many characters in
each record (irrespective of the number of fields)? How are you trying to
import the file?
 
-----Original Message-----
I have a large csv file that i am trying to get into
Access. The problem is that when i import it only the
first 33 of the 105 columns actually go in. Any ideas
would be much appreciated. Thanks!
.
Click to expand...
You probably have a delimiter within the field, e.g., a
comma within the name. You might have a short block in
the text file (bad record) that is only 33 fields long.
Edit the text file and copy / paste a couple records to
another text file and try importing only a couple
records. If that works (105 columns) then you have a
short record somewhere
 
Back
Top