Specification Name for Action:Transfer Text ( in Macro )

[agarwasa2008]

A macro question.

I have action:Transfer Text

with the following settings:
------------------------------------
Transfer Type: import Fixed Width
Specification Name: ??
Table Name: parts
FileName: C:\test\parts.t xt
Has Field names: No

So what does "Specificat ion Name" imply. The text file which I will be
transfering could be space or tab delimited. I do not know at this
point. But would like to know what the "specificat ion name" will be
for the 2 types ie space or tab delimited text file.

Thanks,
Sa

[Benny Andersen]

On Mon, 19 May 2008 17:28:42 -0700 (PDT), ag**********@gm ail.com wrote:

A macro question.

I have action:Transfer Text

with the following settings:
------------------------------------
Transfer Type: import Fixed Width
Specification Name: ??
Table Name: parts
FileName: C:\test\parts.t xt
Has Field names: No

So what does "Specificat ion Name" imply. The text file which I will be
transfering could be space or tab delimited. I do not know at this
point. But would like to know what the "specificat ion name" will be
for the 2 types ie space or tab delimited text file.

Thanks,
Sa

The name of a specific import settings - is saved with the import wizard
(advanced)
--
Benny Andersen

[karsagarwal]

On May 19, 10:18*pm, Benny Andersen <a.mail.u...@gm ail.comwrote:

On Mon, 19 May 2008 17:28:42 -0700 (PDT), agarwasa2...@gm ail.com wrote:

A macro question.

I have action:Transfer Text

with the following settings:
------------------------------------
Transfer Type: * * * * * import Fixed Width
Specification Name: * ??
Table Name: * * * * * * *parts
FileName: * * * * * * * * C:\test\parts.t xt
Has Field names: * * * No

So what does "Specificat ion Name" imply. The text file which I will be
transfering could be space or tab delimited. I do not know at this
point. But would like to know what the "specificat ion name" *will be
for the 2 types ie space or tab delimited text file.

Thanks,
Sa

The name of a specific import settings - is saved with the import wizard
(advanced)
--
Benny Andersen- Hide quoted text -

- Show quoted text -

CAn you give an example? So I can understand how to set it up.

THanks,
SA

[Benny Andersen]

On Tue, 20 May 2008 08:21:27 -0700 (PDT), ka*********@gma il.com wrote:

CAn you give an example? So I can understand how to set it up.

First of all, you don't alwayes have to put a value in this field of the
makro. But specially, when import data contains numbers, you often need an
import specification, because access choose wrong about datatypes
otherwise.
An import specifikation is 'something' contained in the access app file
(the *.mdb or whatever file that 'contains' the database or frontend). It
has to be made. The only way I know of making it, is by following
precedure:

menu line->files->get extern data->import->file types *.csv->mark a
file->import->advanced->set the datatypes and other properties->save
as->make a name for the import specifikation.

--
Benny Andersen