Microsoft Access and Macro

[J.L.Carredano]

Anyone know, within ME10 macro, about possibility of getting data from Microsoft Access Table? Regards

[Stefan Fößel]

Please run Access and then try the following command in ME10 (database.mdb is a Access-Database with the Table Table1): let kanal (dde_initiate "msaccess" "database.mdb; sql select * from Table1" text (dde_request kanal "All")

[Gary Fittro]

Hi Stefan, I tried your input, and was unsuccessful. Could you give me more detail on how to add this to a macro? I set a local variable for "kanal" and typed exactly what you showed, and I get an error stating " ')' expected ", but can't seem to find where to fix it. Also I suspect there might be additional Local variables required. Could you enlighten me? Thanks, Gary

[Vesentini Fausto]

Sono interessato a ricevere le macro