Posted by ckirby on 12/20/05 19:42

I've got a csv that I am trying to import into a SQL Server (2000)
table through an adp (Access 2000). The form used gives the user the
ability to browse for a file, then will import the file into a temp
table for processing using this vba code:

DoCmd.TransferText acImportDelim, , "tmpPaTimeClock2", Me!TimeFileName,
False

When I run the import through the code, the import is dropping any
values less than one (apparently). I've got a couple of columns that
have .5 for the value, but these are brought in as 0. Decimal places
are being imported (ex. 532.28 comes in correctly as 523.28)

I've tried changing the datatype in the temp table, but that doesn't
seem to make a difference.
I've tried letting the import create a new table, but that doesn't fix
the problem either.

If I import the file directly through the adp (right click - import)
all of the values are brought in correctly.

Anyone know how to fix this, or an alternative? I did some reading on
bcp and Bulk Copy, but I couldn't see an easy way to allow for the
variable path name to the file.

[Back to original message]