Thread: Importing Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default 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