Import fixed-length continuous file

  • Thread starter Thread starter JCJM
  • Start date Start date
J

JCJM

Hi. Haven't dabbled in access for over 8 years...would
appreciate any help (or direction to a knowledge base).

Attempting to import a file with fixed-length records,
but no line feed or other character at the end of each
record. It is just one continuous line. Can this be done
within a macro? If so, what would be the necessary steps?

Thanks for any assistance
 
JCJM,

Hmmm, as far as I know this will not be possible without some
shenanigans. You might have to import the whole lot into a Memo field
in a table in the Access database, and then run an Append Query to add
the left x number of characters to another table, and then an Update
Query to remove these same x characters, and repeat the process until
all the text is chopped into separate records. Does this seem feasible?
 
Thanks Steve.

-----Original Message-----
JCJM,

Hmmm, as far as I know this will not be possible without some
shenanigans. You might have to import the whole lot into a Memo field
in a table in the Access database, and then run an Append Query to add
the left x number of characters to another table, and then an Update
Query to remove these same x characters, and repeat the process until
all the text is chopped into separate records. Does this seem feasible?

--
Steve Schapel, Microsoft Access MVP


.
Click to expand...
 
Back
Top