Linking To A New Database File

[Learn2010]

I am trying to do some different things and want to experiment at this time. You may think this is a C# question, but I have searched everything I can and can't find an answer. Everybody seems to understand it differently and do not give good answers. I have found that Access people are more creative, are willing to take a chance, and will understand the question.

I created a C# project. I created a database with a table in C#. Now, I would like to dump my data from Access into that table. The database is an .sdf file. If I can do this, I may use this as an Access FE BE later on. Does anybody know how to do this?

Any help is appreciated. Thanks.

 

[Pat Hartman]

Access (actually Jet or ACE) is accessed outside of Access via ODBC. You will need to use ADO.net, create a connection string, and open a query based on the table in the Jet/ACE database. With VBA, you would use Open/Write to write to a text file. I have no idea what an .sdf file format is or how to access it. It is not a standard file type but if there is an ODBC driver available, that's what you would use.