August 31, 2005 at 2:48 pm
I am using DTS Import/Export Wizard to import an Access Database. Though certain sources are clearly identified as views, the wizard brings them in as tables. Any ideas? I'm running SQLServer 8.
August 31, 2005 at 4:06 pm
when stepping through the wizard - select "copy objects and data between SQL servers" instead of "Copy table(s) and View(s) from source database"...
**ASCII stupid question, get a stupid ANSI !!!**
September 1, 2005 at 1:24 pm
Thomas,
You may have to script out the CREATE VIEW statements from Access and run them on SQL Server to create the views. I only have Access 97, which doesn't allow views, so I can't test this.
Greg
Greg
September 1, 2005 at 3:30 pm
Sushila,
I can use that option on the wizard when DTS from SQL to SQL, but the option is grayed out on a DTS from Access to SQL. Is there a way to use that option on SQL 2000?
September 1, 2005 at 4:07 pm
use greg's suggestion and run the script for the views instead!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply