Access SDF in VB.Net?

[Jigabyte]

Hi Peeps,

I have a PDA application which records audits; these audits are being uploaded to a secure FTP server. I have had some problems with data transfer over the past 6 months so I want to extract the data from the PDA into a HQ Access database using tools in VB.Net. The reason for this is because it would take for ever to write something in CF so I want to write a tool in VB.Net to extract the data I need and import it manually into my Access database avoiding file transfer. I have 6 SDF files to work on.

Is it possible to do such a thing?

Thanks for any help,

Jiggy!!

[petevick]

Hi,
you can use SQLCEClient namespace on your server to read your SDF's and then you can write them to an access database.

Copy your SDF files to your server, and access them locally as you would on the device

[Jigabyte]

Hi petevick,

Sorry for the massive delay; in the end I sorted the problem with the transfer but now I need to read an sdf file in a vb.net desktop application. I can't seem to find SQLCEClient in my references. Do you know where I would find the file?

Thanks,

Jiggy!

[Jigabyte]

I have mananged to get it referenced now but browsing for the dll