Importing Data
Yes it can be done.
Don't know your level of Basic knowledge nor what the records look like
however.
i.e are the records comprised of fixed length fields? If so the Text
Import Wizard will allow you to parse the records without having to
resort to VBA, select "Fixed Width", 2nd dialogue allows you to parse
the record.
If not fixed length fields and the fields have delimiters then select
"Delimited", the second dialogue allows you to specify what the
delimiters are.
HTH
--
Regards;
Rob
------------------------------------------------------------------------
"Alan L. Wagoner" wrote in message
...
Hello,
I have some data in a text file that I would like to import.
Unfortunately,
it's not in CSV format. I was wondering if it's possible in VBA to
open
this file, read in a line, and parse the line as I need, and then
write the
line (cells) to a spreadsheet. Or should I just write a file
pre-processor
(which generates a CSV file) in Java, C, whatever, and import the
data.
I'm not a VBA expert, so I don't know the limitations.
Any help would be appreciated.
Regards,
Alan
|