Other data bases?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
CDO to Retrieve E-mail 7
Quick/efficient way to VBA subtotal 2
Transfer data manually onto other database 4
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Problem mysql import in powerPivot for Excel 2010 1
Disabling users from Save / SaveAs 1

Back
Top