Import csv file to a access table.

S

sos101

Hi,

I have been trying to import a csv file into Access as a table.
The error given me as "File:C:\test.csv" does not contain data" from the
import text wizard.
The file simply contains these line:
6249,Willis,Johnson,1/25/55
2134,Sandeep,Katyal,7/14/74

anybody know why I can't do an import?

thanx!
 
S

sos101

Joseph Meehan said:
Open the file test.csv in word pad and take a look at it. You may want
to post the first few lines for someone to look at.
Click to expand...
Joe,

Here is what I open it with notepad and here is the content

id,firstname,surname,dob
6249,Willis,Johnson,1/25/55
2134,Sandeep,Katyal,7/14/74

It doesn't tell much. Is there some setting in Access for import?

thanx!
 
S

sos101

Joseph Meehan said:
That looks OK. Have you checked to make sure there are no blank lines?
Could there be any kind of problem with the end of line character(s) used?
I'm reaching. :)
Click to expand...
Found the problem! it is caused by the Kaspersky Anti-Virus software that I
am running. I have to disable it and runs ok now.

cheers!
 
Top