March 20, 2003 at 11:21 am
the field names inside the tables without using a view? I am converting a DB from AccessXP to VB6. Basically remodelling it. The approach we've decided to take to try and match our data structure to this other companies and have the same data table structure; one database for the programmers to code from. Alot of our fields contain similar types of data, however we'd like to import it into the same table names. how can this be done without using a view?
March 23, 2003 at 7:19 pm
This is just an idea for you to think about. If you are going to transfer your data from MS Access into SQL Server, use DTS without creating the tables first. When you create your DTS it will give you the oportunity to modify your SQL Sever script to meet your needs. Just an Idea, though. DTS is, for me anyway, the best tool you can use to maipulate your objects and your data. Create the DTS without running it. Just the DTS package, then modify any of the objects or the field to be imported.
Just an idea though.
March 23, 2003 at 9:07 pm
Microsoft also used to have a tool called the Access Upgrade Wizard. I don't know if they still have it for AccessXP but it was specifically designed to upgrade Access DB's to SQL Server.
Tim C.
//Will write code for food
Tim C //Will code for food
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply