Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 This question is specific to Microsoft Access

Author  Topic 

sqlneve
Starting Member

16 Posts

Posted - 2008-12-30 : 11:46:06
Please forgive me this isn't for sql but i'm at my wits end on this one and I know it must be so simple! I'm trying to export a table from access into a .txt file but my id fields now have .00 after all of them. The table doesn't appear this way and I don't want my export this way. I've tried to change the field name data type to different things but i'm stuck. Could anyone help me with this conundrum? Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-01 : 11:30:11
Could you please post this issue in Microsoft access topic?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-01 : 13:21:55
I don't think this is a corruption issue.
Just change datatype for the ID column to an integer column in favor of a decimal datatype.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -