Excel and MySQL

keith · Mar 19th, 2002, 02:02 PM

Has anyone ever used excel directly (or VBA) to query a MySQL databse? Is it possible?

Mark W. · Mar 19th, 2002, 03:49 PM

Do you have the MySQL ODBC driver?

Jack in the UK · Mar 19th, 2002, 04:36 PM

To Add to Mark W

True ODBC will do this, unless large file sizes... SQL is fine but ill be blunt, MSQuery is fine for mick mouse stuff, but as a dtatbase and download skills, we must thank Microsoft for such wonderful developments NOT!

If big.. Access or FoxPro will be better, over ODBC link..

My darling Excel gets stroppy, she dont like it...

Just in case..... telling my directors as i have this is&^$^- )$^*!^$* )$&*!& is not easy, and to say Excel is sulking is not very techi in the IT world

... If you program in SQL.. Fox is strongest if thats of help

Mar 19th, 2002, 04:36 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	To Add to Mark W True ODBC will do this, unless large file sizes... SQL is fine but ill be blunt, MSQuery is fine for mick mouse stuff, but as a dtatbase and download skills, we must thank Microsoft for such wonderful developments NOT! If big.. Access or FoxPro will be better, over ODBC link.. My darling Excel gets stroppy, she dont like it... Just in case..... telling my directors as i have this is&^$^- )$^!^$ )$&*!& is not easy, and to say Excel is sulking is not very techi in the IT world ... If you program in SQL.. Fox is strongest if thats of help __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 02:02 PM	#1
keith Board Regular Join Date: Mar 2002 Posts: 88	Has anyone ever used excel directly (or VBA) to query a MySQL databse? Is it possible?

Mar 19th, 2002, 03:49 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Do you have the MySQL ODBC driver?