SQL server database file

[EMW]

I just finished an application that turns an Excel sheet ( a table of data)
into a Sql server (MDF and LDF) file.
My goal was to use it on the pocketpc2003 to search through the data.

How can I open such file?
In de help files they talk of a database file with the extention SDF.
My file has MDF is there a diffenrence?

thanks,
Eric

 

[William Ryan]

SDF is a specific file format for SQL Server CE. MDF isn't going to get you
there, and there's if you wanted to use PocketAccess for instance, you'd
need to use the ADOCE wrapper or similar product (although that's the only
one I"ve ever heard of).

I'd create a DataSet on the Desktop with my Data, write it to XML, then copy
the file over and import it into CE (you'll need to do this programatically,
but that's not very difficult if you are familiar with ADO.NET which it
looks like you are.) Remember though, CE gets really mad if you try to open
up more than one connection at a time...

HTH,

Bill