Problem with Ymport of CSV file using "From Text"

[JonnieB]

Importing a CSV file using the "From Text" wizard I have 2 problems. Most of the data is text but there are some all numeric enties which give me problems.

1. ,082081, is imported as 82081 dropping the leading zero
2. ,12345678912356789, is imported as 12345678912356700

I've tried setting "Column Data Format" to text in the wizard and tried formatting the destination cells to text before running the wizard but neither cures the problem, I've attached a small CSV file with the problem data.
CSVTest.csv


Can someone set me right please?

[FDibbins]

For any-one else working on this, this is the data in the sample file (saved, and then opened in notepad)...


,Member Name:,Total Run Time (y:d:h:m:s):
,tenfourty,0:001:10:34:25
,superraven0610,0:001:10:30:40
,022a,0:001:10:26:05
,12345678912356789,0:001:06:44:48
,082081,0:001:10:26:05

[aydeegee]

hi JonnieB

Using the data the FDibbins posted above, I managed to get it into Excel from notebook using:

data
from other sources
from Microsoft Query
<New Data Source>
Name - (whatever)
Driver - Microsoft AccessText Driver (*,txt, *.csv)
etc

Does this work for you?

Regards
Alastair