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 |
|
metronome
Starting Member
2 Posts |
 Posted - 2008-04-14 : 08:46:48
|
| From a dts I am creating a new table I then want to export that table into an Access database.When using the dts transformation task it won't save because the table doesn't yet exist.Is there a way to export to an Access db using SQL (a restore command or something?), and therefore bypassing the problem with it not being created yet? |
|
|
jmill130
Starting Member
26 Posts |
Posted - 2008-04-14 : 10:17:36
|
| it should allow you to create a table in access, it should default to the name of your sql table. Using the DTS wizard, this worked for me. |
 |
|
|
metronome
Starting Member
2 Posts |
Posted - 2008-04-14 : 11:26:58
|
| Problem is using the DTS wizard the table needs to exist in SQL server which it doesn't because it hasn't been created yet. |
|
|
|
|
|
|
Export to Access from tbl that hasn't been created