Importing Text file
- From: "SAC" <some@xxxxxxxxxxxxx>
- Date: Wed, 23 Apr 2008 10:32:53 -0500
I want to import a text file and I've tried the Get External Data wizard and
a TransferText macro. It's putting a blank line in the table between. I've
change the field size from 89 to 90 and I still get a blank record between
each filled in record in the table.
It looks like it has 89 characters and then a space, but I've tried
different delimiters (spce, tab) and it still places an extra record in
between.
Any ideas?
Also, I forget how to use readlin...maybe I'd read a line into a variable
and then parse it.
Is it something line Open File as 1...then readln into a varible?
Thanks for any help you might have.
.
- Follow-Ups:
- Re: Importing Text file
- From: SAC
- Re: Importing Text file
- Prev by Date: Re: Programatically add a digital signature to a macro
- Next by Date: Re: Importing Text file
- Previous by thread: Programatically add a digital signature to a macro
- Next by thread: Re: Importing Text file
- Index(es):
Loading