I typically get an ASCII fixed width layout text. With each, I also get a
..txt layout document. How can a turn the layout document into an import spec
file? (Each file's layout is different and Here is a sample of a layout file
I get.

Thanks
Dave



RECORD LAYOUT FOR: XXXXX.TXT
POSITION LENGTH CONTENTS
__________ ______ ________

1- 9 9 Key 1
10- 18 9 key 2
19- 26 8 DOB
27- 27 1 Gender Prime_INDV_Age
28 - 31 4 Name
32- 66 35 address
67- 101 35 city
102- 136 35 state

etc....

Take a look at http://support.microsoft.com/?id=155512

While it only lists Access 95 and Access 97, I believe it applies equally to
all versions.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"dball" <(E-Mail Removed)> wrote in message
news:ED5E9D6C-BF92-4D37-90D8-(E-Mail Removed)...
>I typically get an ASCII fixed width layout text. With each, I also get a
> .txt layout document. How can a turn the layout document into an import
> spec
> file? (Each file's layout is different and Here is a sample of a layout
> file
> I get.
>
> Thanks
> Dave
>
>
>
> RECORD LAYOUT FOR: XXXXX.TXT
> POSITION LENGTH CONTENTS
> __________ ______ ________
>
> 1- 9 9 Key 1
> 10- 18 9 key 2
> 19- 26 8 DOB
> 27- 27 1 Gender Prime_INDV_Age
> 28 - 31 4 Name
> 32- 66 35 address
> 67- 101 35 city
> 102- 136 35 state
>
> etc....