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 |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2005-12-30 : 11:28:29
|
I have been inserting data From Access 2000 using the DTS import wizard. By default, I get the following datatypes Access 2000 SQL Server 2000 datetime converts to smalldatetimetext converts to nvarcharmemo converts to nText Is there a way to change the defaults? I would prefer to have varchar data in SQL server instead of nvarchar, and datetime instead of smalldatetimeMiranda |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-12-30 : 11:34:14
|
| Create the table first in the SQL Server database with the datatypes you want, and then use the DTS wizard to load data into it.CODO ERGO SUM |
 |
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-30 : 12:19:41
|
| Then it is easier to click the transformation button and change the data type. is there no way to change the default?Miranda |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-30 : 14:00:11
|
| Before you start to import, choose the datatype you want in DTS IMPORT/EXPORT utility |
|
|
|
|
|
|
default datatypes using DTS Import