index > SQL Server Everywhere Edition > How to add data in sql mobile database from sql server 2005 manag...

How to add data in sql mobile database from sql server 2005 manag...

Hi,

After creating mobile database into sql server 2005 management studio, how to insert the records from sql server 2005 management studio into and mobile database from excel file?

Thank you

Prashant

prashant mulay

There is no automatic tool (or out-of-box usable tool) which you can use to import data into SQL Mobile from excel or .csv file. You need to write a small app that reads the data/rwo from excel file and inserts into SQL Mobile database.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

Please hit "Yes", if my post answered your question(s). All postings are as-is and confer no rights.

Laxmi NRO MSFT

reply 2

You can use google to search for other answers

More Articles

• Hosting SQL Everywhere In a Windows Service

• cannot generate ResultSet code

• RDA with Linked Servers

• Can I use SQL Server Management Studio Express to work with SQL S...

• Getting started with SQL Server Mobile

• SQL 2005 Mobile vs .NET CF 2.0 SP1?

• Help SQL CE Query - LOW Performance

• Need help regarding Replication between SQL Server 2005 and SQL S...

• Can't see Designer view in Asp.net 2005

• Has anyone noticed a size difference between 2.0 and 3.0?

Welcome to Bokebb New Update

New Articles

• Alter statement to create foreign key re
• HostName and ReinitializeSubscription
• fastest way to do large amounts of updates
• RE: SQL Mobile Get Started Tutorial
• Inner workings of RDA
• Synchronize SQL Mobile 2005 using Active
• Error when "SELECT" statement
• Unable to perform a Manual install of SQ
• SCOPE_IDENTITY()
• SQL Server mobile installation
• sql server CE supported classes
• RDA Pull with existing table
• Create .SDF from .MDF File
• SQL Mobile - Locale Not supported
• Upgrade scripts for SQL Server Mobile Da

Hot Articles

• SQL Server Mobile - Latest Version?
• (SQL Mobile)Can SELECT, but cannot INSER
• My Mobile DB.
• SQL Everywhere - Can't connect from VS.N
• accessing records
• Alter statement to create foreign key re
• EDB - CeGetDBInformationByHandle
• SQL Everywhere, ntext & ADO Classic
• Data Access Application Block for SQLCli
• Not all subscriber types in New Subscrip
• unable to connect to sql server from han
• Id getting generated differently
• Is there something similar to SQL 2005 r
• SQL CE Push ConnectTimeout
• Newbie: "Sql mobile" or it is

Recommend Articles

• Storing bulk data from dataset to sql mo
• The path is not valid. Check the directo
• Getting replication to work on Windows 2
• Setting up publication for merge replica
• Question: Can i synchronize the mobile d
• VS2005/SQL Server 2005 Mobile subscribin
• Need help regarding Replication between
• Visual Studio Configure Sync Settings di
• Error Saving Binary data to sql mobile
• Dates problem in SQL Server Evrywhere ed
• Connection String Encryption for SQL Ser
• ISNULL ( ) support in SQL Server mobile?
• Inner workings of RDA
• Mobile Application Enquiry
• Cannot save English dates!