Database

SELECT tt.IdAmlak, tt.ParentId, tt.NameOpp, tt.Price, tt.[Square],
       tt.OstanShahrMantagha, tt.PhoneAddress, tt.CountAmount
INTO TestTable
FROM tblTesting tt

tblTesting :  Table in database Sql Server 2008 in server internet <br />
TestTable  :  Table in Database SQLite in local (android mobile)

csv file and processing it locally

if you can have an ODBC connection to the server on the web, and one to the android device

insert into CRM-CMS.dbo.tableName
select * from [217.66.216.77,1633].CRM-CMS.dbo.tblTesting

cmd.CommandText = @"SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir'
                 ).[CRM-CMS].dbo.tblTesting";

i got this code :
but cannot run for SQLite :

i get this error in sqlite :

<code>SQLite error near "INTO" : syntax error </code>


<pre lang="sql">cmd.CommandText = @&quot;SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         &#39;SQLOLEDB&#39;,
         &#39;Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir&#39;
                 ).[CRM-CMS].dbo.tblTesting&quot;;</pre>

Insert Melk (field, names, list) Select ...

select sum(iif(FIELDNAME = 'Bundle', 1, 0)) as NumBundles,  
sum(iif(FIELDNAME = 'Bowed Board', 1, 0)) as NumBowedBoards,  
sum(iif(FIELDNAME = 'Jam', 1, 0)) as NumJams  
from TABLENAME

Select Fieldname, Count(*)
from Tablename
Group By FieldName

SELECT CAST(ISNULL(COUNT(ProdType),0) AS VARCHAR(10)) + ' '+ ProdType FROM ProdDtls GROUP BY ProdType