I am trying to import a TXT file into a Personal SQL Server database and the DTS wizard is changing the number format, making it unusable.

Example of Data before importing: .000283
Example of Data IF import works without a Microsoft JET database error msg: 4.53928375464-E x3 (or something like that).

I have tried transforming the data type during the DTS Import Wizard, but all the results I get are either 0 or 1, or I get a Microsoft JET Database error message.

I want the result to be the same .000283 that was in the original table.

Any help would be appreciated.

Thanks!

Nathan

Can you provide us with sample data on Access and the schema?
What does the SQL Server table look like?
How are you choosing to view the data?
Is this a client formatting issue?
Any errors?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org