MySQL ODBC to Excel

  • Thread starter Thread starter rjre
  • Start date Start date
R

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
 
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.
Click to expand...

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.
 
Back
Top