How many ways are provided by Microsoft to import data into SQL Mobile database?

SQL Mobile database seems to not provide import/export utilities.

I think using Publication/Subscription is one of the solution, is it right?

Also, besides typing insert statement manually, there are any other ways to transform data to the SQL Mobile database?

There are no formal Import or Export programs/utilities for SQLCe at this point and there is no bulk copy class in the SqlCe namespace. Yes, you can setup a SQLCe database as a subscriber in a Merge replication configuration against a SQL Server Workgroup or better server. You can also write your own INSERT scripts (as I illustrate in an an example in my EBook). Exporting data is simply a matter of writing a class that exposes a DataReader against the database--SqlClient can read that data stream and import it into SQL Server using SqlBulkCopy. This is discussed in my new EBook. See www.hitchhikerguides.net.|||Or simply read it into a dataset and the write it with the XMLWriter.

Here is some sample code for doing the INSERT that was written in a previous post (near end)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=926140&SiteID=1

how import DB(arabic) file to sql server?

hi

I have a BD (paradox) file, and have to import to sql server .

i imported that to access successful, but my data not correct (my data is in Arabic and Persian) like this: ?óì? ì?????

Please help me.

this because of codepage or collation

import to sql in a field with datatype nchar (unicode) if u want to maintain arabic and farsi in same field

|||

Try to use this DTS http://www.microsoft.com/middleeast/msdn/CPDTS.aspx

how import DB(arabic) file to sql server?

hi

I have a BD (paradox) file, and have to import to sql server .

i imported that to access successful, but my data not correct (my data is in Arabic and Persian) like this: ?óì? ì?????

Please help me.

this because of codepage or collation

import to sql in a field with datatype nchar (unicode) if u want to maintain arabic and farsi in same field

|||

Try to use this DTS http://www.microsoft.com/middleeast/msdn/CPDTS.aspx

How import data using DTS from Excel 2007?

Hi,

I wants to import data using DTS package from Excel 2007. I have tried this by using DSN but i'm not getting Excel 2007 types.

Please suggest me how to Connect to Excel 2007 using DTS package to import data.

Thanks!

these are the steps.

1) write click on the Database

2) select Task - ImportData

3) select microsoft Excel from the drop down list and then browse and select the file u want to import. click next.

4) then select the database, give the username and password if any to access the databse or sql server. click next.

5) select the first option, click next, click on the sheet name of the sheet u want the data from and then in the destination select the table where u wanna put the data too. Click on edit mappings and see going where it has to go .

6) click next and finsh , u can save the package for future use and just replace the file and run the package again.

Hope this helps.

Regards,

Karen