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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-06-25 : 13:25:51
|
| How do i convert a table from Microsoft Access to sql server table? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-06-25 : 13:38:40
|
| Some would say use the Import Data wizard in SQL server, but If you want just one table, I'd say make the table by hand with either a CREATE TABLE statement, or use Enterprise manager. The reason is when you do the "upsize wizard" or Import data wizard, it makes all of your text fields into an nVarChar, instead of a VarChar.If you want to move both the data AND the table, use the wizard, and make sure you specify the correct field datatypes when you use the wizard.Michael--------------------<Yoda>Use the Search page you must. |
 |
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-06-25 : 13:46:16
|
| Thanks Michaelmarls |
|
|
|
|
|
|
Microsoft Access to sql server table