stanl
06-13-2007, 05:16 AM
I have a VBA sub that inputs large (avg: 350meg) text files assigning each line input to a variable, fline; manipulating fline and outputing to a .csv that is imported into an Access Table. A typical line [finally] appears as
fline = "Somename,060107,read,34567,891" then I
Print #2, fline
which gets reformatted via an Access make table query as
Somename,20070601,read,34567,891
[all dates are after 2000]. Is there someway I can make the date transformation while still in the variable fline, prior to the Print statement - split()??? Instr()??? or something??? :dunno Stan
fline = "Somename,060107,read,34567,891" then I
Print #2, fline
which gets reformatted via an Access make table query as
Somename,20070601,read,34567,891
[all dates are after 2000]. Is there someway I can make the date transformation while still in the variable fline, prior to the Print statement - split()??? Instr()??? or something??? :dunno Stan