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.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-10-25 : 13:53:22
|
| I have one particular column that only shows data in part of the rows.In Excell, the format property indicates the data is in text. They looks like this:0012001311251278However, after linked it to the Access, when it is open in Access, only numbers with leading zero show, others show as #Num!00120013#Num!#Num!What is the trick to make them show?Thanks! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-26 : 06:45:47
|
| Off the top of my head....(and slightly guessing)...would the datatype in Access be too small to deal with the offending numbers? |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-10-26 : 10:18:49
|
| Yah, that was one of the things came to my mind first. Then, both 00115678 and 10115678 are same length text strings.I remember somewhere on MSDN talking about regardless the data type, the receiving program makes judgment about the data type based on the first x number instances of data. In my case, it sees several rows with leading zero, then when it runs into rows without it, it refuse to recognizes them.If I forced the data in excel to be '10115678 with an apostrophe in front of it, then it shows up in my linked table. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-26 : 10:29:45
|
| "...Then, both 00115678 and 10115678 are same length text strings."but as numbers the leading 0's don't count..... |
|
|
|
|
|
|
|
|
linked excel worksheet problem