create mobile database from xls, csv, text or mdb

Hot Topic

Average Over Last Two Years
Wrong values stored in a field of Datatype Float
long running report can not be rendered in Report Manager or through Subscription
Connecting to SQL Server 2005 from Classic ASP
Sorting Data in a Table
sql statement
new 9.0 GP dynamics & SQL 2005 upgrade
Sql Express database issue
Reporting Services setup and problems
Unknown source of backup commands

SQL Server

Flat File Source - Add Output Field
Report Corruption When Exported to Excel
Header and Footer in Report Builder
Search Stored Proc
Cannot open offline cube
How to make distributed query by SQL Express
SQL Express Failed Login & Service Restart
Is there a performance hit if I run with a db on compatibility level 80 in sql server 2005?
Report Execution timeout after 60 minutes (1 hour) - Execution cannot be found (rsExecutionNotFound)
TSQL Queries against Cubes in SQL Server 2005

create mobile database from xls, csv, text or mdb

Hello,

Since my experience in VS is extremely limited, i'd like to be exused if questions sound silly.

My problem is that, at my device application project, i want to build a database that will retrieve data from .xls, or .csv, or .txt, or .mbd files. If i've noticed well, there is no support for OLEDB or ODBC, since by the time that i add tableadapter to my database.xsd and use these, after insertion i get multiple errors informing that system.data.oledb. .... or .odbc "type is not defined".

If it cannot be done, and since i still try to figure out how smart devices function, transact with databases, e.c.t. is there any suggestion

Thank you in advance

Kostas

Answer this question

create mobile database from xls, csv, text or mdb

  • FlashyPants

    you'll likely need to use sql server mobile.

  • DevDiver

    Thank you Andrew, i'll take a look at accessSynchronizer. If my knowledge and experience wasn't so poor i could ask about the code for importing CSV since this is the format that interest me more, but i guess that it will be rather difficult for me fix.

    Thank you very much

  • Geoff Stockham

    I'am trying to do so with sql mobile.

    Going-> right click on "deviceapplication1" -> add -> new item -> sql mobile database

    This gives me an empty database. In order to fill it i go at server explorer, right click on "AppDatabase2.sdf" (new created database), -> modify connection -> change (data source field) -> i choose microsoft ODBC data source -> user or system data source names: ms access database -> OK. Then browsing for mdb file (my access databace), and it's in server explorer; no problem yet. Then going to solution explorer, opening "AppDatabase2DataSet.xsd", drug & drop tables from server explorer to "AppDatabase2DataSet.xsd" (making table adapters( )). Then i get this huge error list that "system.data.odbc...." Type is not defined.

    Either i need to add some reference (as i did at VBA) since even autofill doesn't work (I try at the top of code to insert "imports system.data.odbc), or it's just not supported in sql mobile database

  • KirkAtCenterstance

    That is something that i have already understood after some experiment.

    The question is how sql mobile works and if i can update the tables from an external (server or just a given path) sourse. I have created an sdb, with the tables required, but this tables are empty, and need to be updated each day from source files of the above mentioned format.


  • mike6271

    I believe opennetcf has a csv importer, you may want to consider that ...

    this post is a bit old, but may still be relevant:
    http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_thread/thread/671b1480a962e8e0/92d0ba873b07398d%2392d0ba873b07398d

  • adi151478

    I'm not a drag and drop type of guy, but from what you've said, you're trying to create a set of adapters between Access and SQL Server Mobile -- you can't do this, there's no ODBC implementation within NETCF for the CF to talk to Access. I learned yesterday from a posting by Ilya Tumanov that there's a util called AccessSynchronizer for Access<-->SQL Server Mobile synchronization, you may want to look into it. Personally I'd just dump the stuff from Access into XML or CSV, and import using my own code, but that may not be for you. Another option is to wrap your datasource in a web service and proxy the sync operation that way.

  • shaul_ei

    you can't use access as your datasource. appdatabase2.sdf IS your sql server mobile database, and that needs to remain your datasource. no odbc, no ole db in NETCF. your only mobile database option for .net development is a sql server mobile DB.
  • create mobile database from xls, csv, text or mdb
Answer this question