This is probably more of a VBA question but you should be able to find a code solution in the below post:
Unfortunately you cannot create a linked table to a SQL Server Compact Edition database because there is no ODBC driver for the platform.
Paul ~~~~ Microsoft MVP (Visual Basic)
Is it possible to open a .sdf file in Microsoft Access?
Not you cannot....
because sdf. is a compact database created by sqldatabase.....
I think what you mean is to laod information from SDF to MS access, yes that is possible...
Can you explain what do you mean or what are you trying to do?
All the best for you....