I have a text file that I would like to import into a table using a macro,
but I am having difficultly understanding the help file.

1. Selected TransferText from the Action Window.
2. Transfer Type = Import Fixed Width
3. Specification Name ??????
4. Table Name = Test
5. File Name = C:\Temp\175updt.txt
6. Field Names = No

I am confused with the Specification Name. I have read the help file but I
am unsure what arguement to use and the schema.ini thing lost me. Sure
would appeciate some assistance.

Thank you

Hi Duane

Do the first import by hand, using File->Get external data.

After you have specified all the field names and types and widths, click the
"Advanced" button, and save the specification with a meaningful name.

Then you can use the name in place of ??????.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Duane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a text file that I would like to import into a table using a macro,
>but I am having difficultly understanding the help file.
>
> 1. Selected TransferText from the Action Window.
> 2. Transfer Type = Import Fixed Width
> 3. Specification Name ??????
> 4. Table Name = Test
> 5. File Name = C:\Temp\175updt.txt
> 6. Field Names = No
>
> I am confused with the Specification Name. I have read the help file but
> I am unsure what arguement to use and the schema.ini thing lost me. Sure
> would appeciate some assistance.
>
> Thank you
>

Thanks Graham! It was much easier than I thought it would be.


"Graham Mandeno" <(E-Mail Removed)> wrote in message
news:A08FF401-0B72-4BFE-A3F4-(E-Mail Removed)...
> Hi Duane
>
> Do the first import by hand, using File->Get external data.
>
> After you have specified all the field names and types and widths, click
> the "Advanced" button, and save the specification with a meaningful name.
>
> Then you can use the name in place of ??????.
> --
> Good Luck :-)
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
> "Duane" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have a text file that I would like to import into a table using a macro,
>>but I am having difficultly understanding the help file.
>>
>> 1. Selected TransferText from the Action Window.
>> 2. Transfer Type = Import Fixed Width
>> 3. Specification Name ??????
>> 4. Table Name = Test
>> 5. File Name = C:\Temp\175updt.txt
>> 6. Field Names = No
>>
>> I am confused with the Specification Name. I have read the help file but
>> I am unsure what arguement to use and the schema.ini thing lost me. Sure
>> would appeciate some assistance.
>>
>> Thank you
>>
>
>