Access SQL Project Import csv

[Sara]

Using TransferText command to import .csv file I get the following error:

ODBC-insert on a linked table ??? failed
(Microsoft)(ODBC SQL Server Driver)Fractional truncation(#0)(Microsft)(ODBC
SQL Server Driver)Invalid character value for cast specification(#0)

When i run the File Get External Data Import .csv from Menu bar manually the
import works fine.
docmd.TransferText function produces the error

More background: I copied the main SQL Table (structure only) and am
running TransferText to pull data into this temporary table. In this
temporary table I deleted the ReplicationID field. Some changes will be made
to data in temporary table and then appended to the main table.

Appreciate recommendations... Have used TransferText frequently forimports
and exports with no problem, so I am surprised by this result.

 

[Jack Dahlgren]

You might try posting this in one of the SQL server newsgroups. This group is
for Microsoft Project and Project Server.

-Jack Dahlgren

 

[Sara]

thanks Jack
--
Sara

You might try posting this in one of the SQL server newsgroups. This group is
for Microsoft Project and Project Server.

-Jack Dahlgren