Specification Name for Action:Transfer Text ( in Macro )

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

agarwasa2008@gmail.com - 20 May 2008 01:28 GMT

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.txt
Has Field names: No

So what does "Specification 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 "specification name" will be
for the 2 types ie space or tab delimited text file.

Thanks,
Sa

Reply to this Message

Benny Andersen - 20 May 2008 06:18 GMT

> A macro question.
>
[quoted text clipped - 15 lines]
> Thanks,
> Sa

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

Signature

Benny Andersen

Reply to this Message

karsagarwal@gmail.com - 20 May 2008 16:21 GMT

> > A macro question.
>
[quoted text clipped - 22 lines]
>
> - Show quoted text -

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

THanks,
SA

Reply to this Message

Benny Andersen - 21 May 2008 06:53 GMT

> 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.

Signature

Benny Andersen

Reply to this Message

Rate this thread: