Dropping preceeding zeros in text field

[barra47]

I am importing data from a comma delimited text file
the supplier invoice number is a text field.
I am using Transfer text in a macro to do this
some of the invoice numbers are e.g. 0008744, 08899, ab234 etc.
when it is imported into the database table , into a text field it drops the zero's e.g. 0008744 becomes 8744
how can I stop this as it is important to keep the zero's


Thanks in advance

 

[Remou]

Are you using an import specification?

 

[barra47]

Yes iam
within a macro : Transfer Text

Transfer Type: Import delimitted
Table name : ReconDetail
File name: C:/Txt File/ReconDetail.txt
Has field names : No

 

[PHV]

Yes iam
No, you don't.
Remou talked about the Format parameter of this action.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[barra47]

Sorry I misunderstood the question
Im just using the macro as explained. I am open to suggestion.

 

[Remou]

You need an import specification. See "About import/export specifications and schema.ini files" under

http://office.microsoft.com/en-us/access/HP052416491033.aspx?pid=CH063648341033

 

[PHV]

Do you know what Import Specification means ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[barra47]

Sorry
I do not know what Import specification means

 

[PHV]

So, read the About import/export specifications and schema.ini files. paragraph in the link provided by Remou.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[barra47]

Thank you both for your time
I just worked out if I run get data it brings in the text as is without removing the preceeding zero's

Thanks