Import csv file to a access table.

[Guest]

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!

 

[Joseph Meehan]

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!

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.

 

[Guest]

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.

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!

 

[Joseph Meehan]

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.

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.

 

[Guest]

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.

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!