[RESOLVED] how to import and export MsAccess data to SQL mobile

[kryptonboy22]

how ca i import and export MsAccess data to SQL mobile or vice versa. or to SQL 2005 to sql mobile. im using emulator. thanks!

[petevick]

Hi,
if you search the forums - this has been asked and answered before.
For Access, basically you need to write something , or use a 3rd party.
You could also try acccess synchronisation services from Microsoft. Shaggy Hiker has done some synch work - take a look here

For Sql2005 to SqlMobile, there is Replication, or you have a SqlClient available on PocketPC.

Is this a 'one-off' data transfer, or an application?

Pete

[kryptonboy22]

Whow! Thanks Mr. Pete Vickers! Im a fan of yours! thanks a lot

[kryptonboy22]

ah sir! the link you gave me is not valid and another i found a link from one of the thread about the synch for mdb... but the file is not available anymore in microsoft site.

[petevick]

Hi,
this should get you the Access Sync tool, and the stuff from Shaggy should be here

Pete

[kryptonboy22]

Shaggy's link... that's the one that im talking about. the file can no longer be downloaded but the one you gave its working... ill be working on it now! thanks sir!

[Shaggy Hiker]

There was nothing to download in the thread I had, except for the link that petevick posted in that thread. I guess you probably got that re-posted.