Conversion of Access to SQL 7.0

[libby]

I have developed a database in Access, but now need to convert it to SQL 7.0. Please let me know the most efficient method or reference material that will direct me in the procedure.<br>
<br>
Thanks

 

[stingman]

The SQL 7 comes with a way to convert from access to SQL and it works pretty good I have used it several times to convert my databases. You just choose import and pick the database. <p>Steve Hagerman<br><a href=mailto:Admin@asr.cx>Admin@asr.cx</a><br><a href=

http://www.asr.cx/>FREE

service's</a><br>

 

[Guest_imported]

Unfortunately, I have Never found an easy way to import queries from Access to SQL 7. I had to convert over 300 queries by hand a while back. It really was a pain, and I always had my boss looking over my shoulder asking &quot;isn't there a better way of doing this?&quot; <br>
<br>
If there was don't you think I'd be using it? (silly boss)<br>
<br>
Anyway, though SOME SQL can be easily converted, there are way too many differances. I did find that I could keep some Access Queries &quot;as is&quot;, then do just a little editing, and some fancy ODBC footwork, use SQL to store the data on, and Access as a front end. Thereby saving a LOT of aggravation and time.<br>
<p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://computerwiz.net>ComputerWiz</a><br>