Migrating DB From Access to SQL 7.0

[Guest_imported]

This'll be an easy one for all you experts - how do I convert an MS Access database to be used in SQL V7.0?

Thanks for your help

 

[MalcolmW]

There is a "Microsoft: SQL Server" forum that may be a better place to find SQL Server gurus - this a generic SQL forum, and unfortunately, SQL Server is a few steps away from being ANSI standard SQL (a pet peeve of mine). [sig][/sig]

 

[THoey]

What? Bill Gates follow a standard? Blasphomy!!!

[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[listener22]

On MS's download page(s), there are documents and
utilities relating to this type of conversion. [sig]<p>Jim<br><a href= > </a><br>oracle, vb, some javascript[/sig]