Very confused access newb and need help!! 
I'm trying to write a macro to import csv files into a mdb.
I've searched the forum and found some examples, but im truly lost.
A sample of the csv file is below.
So currently I manually import the data with the following steps
1. 1st row contains field names.
2. skip first column (as its all blanks)
3. import all other cols, but with last column I import with a MDY format.
4. import into existing DB
All help would be great
Many Thanks
There is about 200,000 rows in each file!
I'm trying to write a macro to import csv files into a mdb.
I've searched the forum and found some examples, but im truly lost.
A sample of the csv file is below.
So currently I manually import the data with the following steps
1. 1st row contains field names.
2. skip first column (as its all blanks)
3. import all other cols, but with last column I import with a MDY format.
4. import into existing DB
All help would be great
Many Thanks
Code:
,ÿþComputerName,ObjectName,PerformanceCounterName,PerformanceInstanceName,SampledValue,TimeSampled
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,2.24748899462693,07-01-2007 00:05
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,4.15209282684479,07-01-2007 00:09
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,4.08122189087369,07-01-2007 00:15
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,2.59458327199961,07-01-2007 00:20
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,1.66944401777505,07-01-2007 00:24
,LIV-CER-WA-P01,LogicalDisk,% Disk Time,_Total,2.04877977885725,07-01-2007 00:29There is about 200,000 rows in each file!
