MySQL ODBC to Excel

[rjre]

Afternoon all,

Having searched seemingly everywhere i think i can guess the answer i
am going to get - but here goes...

Using the MySQL ODBC client I can pull data from my database into
Excel. Is it then possible for me to directly edit this data from
Excel into the database - this is "possible" from within Access.

Thanks

Richard

 

[Dick Kusleika]

Having searched seemingly everywhere i think i can guess the answer i
am going to get - but here goes...

Using the MySQL ODBC client I can pull data from my database into
Excel. Is it then possible for me to directly edit this data from
Excel into the database - this is "possible" from within Access.

You guessed it...Nope. External Data in Excel is a one way street. You can
write to a database using VBA, but it's not a trivial task.