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 |
|
cirugio
Yak Posting Veteran
90 Posts |
 Posted - 2011-05-12 : 10:48:42
|
| Sql Server 2008's Export Wizard to Access db converts all varchar fields to memo. How can I change this so it exports it as text? In the SQL Export Wiz, on the "Select Source Table and Views" , I clicked the "Edit Mappings..." button next to the table that contains a varchar and ensured the field datatype selected is varchar. Not sure why this is happening. Similiar issue is happening when I try to export datetime variable to access. It appears the datetime gets converted to text even though I selected datetime datatype from the 'Select Source Table and Views' edit window?Any suggestions why this is happening and how to correct? Thanks for your time in advance. |
|
|
|
|
|
Export Wizard to Access converts vchar to memo