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 |
|
nancy25dec
Starting Member
3 Posts |
 Posted - 2008-02-28 : 00:01:05
|
| Hello,I am trying to import data from Excel to Access. My excel worksheet have a coulmn called account number which have values of number or text. Like (777, 789,741,753,7-12,71-5,7-58,7-23). At present it only imports values that have no hyphen(777,789,741,753) in it. and treats all other values as text and would not import values with hyphen(-).Can I force so that all account numbers are treated as text and imports all account numbers. Your help will be greatly appreciated. Thanks Nancy |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-02-28 : 00:03:51
|
In the access wizard for the import, you can specify how to treat the column coming in. Just specify that the column coming in is text, or value depending on what you want it to be.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
nancy25dec
Starting Member
3 Posts |
Posted - 2008-02-28 : 00:30:10
|
| Oh! I am using a DTS Package to import it. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-02-28 : 21:44:19
|
Modify the column transfer properties inside the DTS Package itself. modify the column mapping cast the source column as a string.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
|
|
Error Importing Number and text values