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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-10-15 : 09:59:31
|
| Hey DTS programmers.I have a SS 7 and I am attempting to export several tables to an access db so users can download the db and play. This is quite basic (in my mind) but the dts wizard doesn't seem to grab all the fields and export them correctly. It skips some fields and because of the mismatch, tries to copy a varchar to a datetime field (for example). I realize I can manually edit these problematic queries but figured I am missing the boat on this somewhere.(I am doing drop and recreate on the tables, btw).Thanks for any insight._________________________Death is one day closer |
|
|
|
|
|
DTS -> Access