Other data bases?

A

Albert

Hello!
I am a Vba/Excel fanatic and have made several succesful applications. I was
wondering, however, how can I use VBA with other data bases such as MySQL?
What is the procedure for migrating to other data bases? Could you give me
some advice for using a succesful application with a database that is about
to reach the 65536 row limit?
I thank you in advance,
Albert
 
B

Bob Phillips

Why don't you store the data in a MySQL database, and use Excel to query
data using ADO. Your SQL can select the records you need, or even summarise
it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top