Importing data from a MS Access Database

[StevenK]

We're looking at re-creating a Microsoft Access database as a SQL server 7.0 database. If we use the 'Import/Export data' option we are able to create and populate the tables but this does not maintain the indexes for the tables. Is this achievable ?
Thanks in advance.
Steve.

 

[Bernadette]

Hi Steve

I dont quite understand what you are trying to do. Is the database going to be a sql server db or an msaccessdb. And where do you want to import the data to? Bernadette

 

[StevenK]

We have an existing Microsoft Access database and are looking at creating a SQL Server 7.0 database from this - maintaining the same table structure and data - the problem is the maintaining of the indexes and table constraints. Can anyone offer any suggestions ?
Steve

 

[Bernadette]

Hi Steven

Have you tried using the MS Access Upsizing Wizard
to upgrade this to a sql server database.
You can download it here. It is for Access 97. Is this the version of Access you are using?

http://office.microsoft.com/downloads/9798/aut97.aspx

Once it is a sql server 7.0 you can then use the "DB Maintainance Planner" to shedule jobs to run every night to maintain your indexes and back up your database."
Is this what you are trying to do ?

Hope this helps Bernadette