I'm hoping to connect an SQL CE file (main.dat) to an Access DB so I can run some vba code which:
1. Uses DAO to open a recordset (a table in the SQL CE DB)
2. Uses a field containing paths to mp3 files to extract the id3 tag data
3. Update an existing field from the same table/Same SQL CE DB
I've looked around and can't seem to find any ODBC driver(s) for SQL CE. Got some info from Erik
who suggested I post here.
Thanks in advance!
EDIT: I just now was able to get Erik's code to work in Excel from my DB. But I'm not sure how to send it back to the SQL CE DB from VBA... Is it possible?
View Complete Post