how to copy MS Access mdb file to PPC as SQL CE sdf file

[AlexAngAB]

I wish to develop a PPC program that access SQL CE.

I need to export the mdb file (40MB) to PPC/emulator as SQL CE sdf
file. One way is to run SQL statement: create table and insert for say
7000 records. This is very tedious and time consuming.

Development tools used are: VS.Net 2003, .NET CF, SQL Server 2000.

Could you suggest a faster way to do such task?
Thanks.

 

[Marcantonio]

I need to export the mdb file (40MB) to PPC/emulator as SQL CE sdf
file. One way is to run SQL statement: create table and insert for say
[..]Development tools used are: VS.Net 2003, .NET CF, SQL Server 2000.

You might consider using Visual Studio 2005 and framework 2.0, since you
can use .sdf files on the desktop by referencing the appropriate libraries.

I didn't find an easy way to do that in vs2003.

Marcantonio