Importing taxt extract file with Numbers and decimals

[Sweetetc]

I have an extract file with a .txt extension that is too large to import into
Excel prior to Access. One of the fields contains a number with a 3 digit
decimal. When I try to import directly to access this field comes over as a
text field dropping the 3 decimal places. I have no way to modify the
creation of the fields in the extract file while it is being created.

Any suggestions on how this can be imported to maintain the 3 decimal poin #
12345.123?
Thanks
ETC

 

[Ken Snell \(MVP\)]

Are you using TransferText (macro or VBA) to do the import? If yes, create
an Import Specification that defines that particular field's contents as a
number.

If you're not using TransferText, you will need to use it.

 

[Sweetetc]

What is transfertest? Is it an application that I need to load? I just
tried to Import via access 2003 MS Access.

 

[pietlinden]

TransferTeXt... it was a typo.

 

[Ken Snell \(MVP\)]

TransferText is available in a macro or via VBA code. It's built into
ACCESS. See ACCESS Help for more information about it.

 

[PatrickMc]

Data import using biterscripting

You can process the data file using biterscripting ( http://www.biterscripting.com for free download) before importing.

There are couple of good examples at http://www.biterscripting.com/SS_Datafile.html and http://www.biterscripting.com/SS_CSV.html .

If necessary, you can modify these scripts to convert data columns into 2 decimals, etc.

Patrick