Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conversion of Access to SQL 7.0
- Thread starter libby
- Start date
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= service's</a><br>
Guest_imported
New member
- Jan 1, 1970
- 0
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 "isn't there a better way of doing this?" <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 "as is", 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=
<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 "as is", 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=
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question