Specification file in VBA for Access

[innovative1234]

Hi,

I am new to VBA for Access.

I am trying to locate the specification file "ABC" provided in the following statement of VBA code.

DoCmd.TransferText acImportFixed, "ABC", "tblTextABC", filename

Can someone please tell me in what ways the specification files are created?

Thanks

- Amit

 

[PHV]

Can someone please tell me in what ways the specification files are created
With the external data import wizard

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[innovative1234]

Thanks PHV.

Can you give more details here.

How to access the External Data Import Wizard?

Where is the spefication file stored?

I am new to MS Access so appreciate if you can give more details.

Thnx!

- Amit

 

[PHV]

How to access the External Data Import Wizard?
When in database window, menu File -> External data -> Import ...
The spelling may be different as I don't use an english version of office.
Where is the spefication file stored?
If I remember right, on two MSys??? tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[innovative1234]

Thanks PHV.

Got answer to first question.

But still not clear on the second one
>>
Where is the specification file stored?
If I remember right, on two MSys??? tables.

What did you mean by two MSys? - Could you elaborate?

TIA

- Amit