Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-03-2009
Member
 
Join Date: Feb 2009
Posts: 69
How to add csv files in dataset base

Hi

I try to import a .csv file to my dataset base but when i want used
OleDbDataAdapter, i have error.

my connection string :

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"DataSource=c:\somepath\csvfile;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""

Thanks for help
Reply With Quote
  #2  
Old 26-03-2009
Member
 
Join Date: Dec 2008
Posts: 202
Re: How to add csv files in dataset base

You probably need to loop through each line of your CSV and create a DataRow from the data. Then add the DataRow to your DataTable.Or you try the following File - New - Database- Connect to an existing DB-Text-Next - Browse to your csv.

Alternatively you can Copy-Paste your data from Calc to Tables folder inBase.
Reply With Quote
  #3  
Old 26-03-2009
Member
 
Join Date: Dec 2008
Posts: 161
Re: How to add csv files in dataset base

Here i will add my experience for your reference,I have just about given up completely using OOo for this project. The new version of Base has so many problems and limitations that it is unusable. I also have OOo 2.3 on Windows and it cannot access the MS Access database either. It almost does, but throws an error at the last minute. It also cannot open the .csv file in Base - it will open it only in Calc. And you're supposed to be able to drag the table from Calc or copy and paste from Calc into Base, but that also does not work
(on either platform).

Unfortunately, OOo cannot read an SQLite file (the Kexi file format) either, so my only option is KWord. Right now I'm trying to figure out the KWord user interface to mail merge (almost as unintuitive as Base).

I used to use OOo/Linux to merge data directly from the Access .mdb file and it always worked beautifully. I guess someone decided it wasn't broke so it was time to fix it.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to add csv files in dataset base"
Thread Thread Starter Forum Replies Last Post
Dataset vs DataReader in .Net Vireshh Software Development 3 07-05-2011 11:32 AM
Outlook 2010 - Sending HTML base .oft Files is converted to RTF Riverds Windows Software 4 19-10-2010 04:06 AM
How to use dataset in ASP.Net? Roxy_jacob Software Development 3 28-11-2009 06:13 PM
How is DataSet.xsd used in any particular website Guns-n-Roses Software Development 3 25-09-2009 12:52 PM
Working with XML and DataSet Aanand Software Development 3 01-05-2009 02:38 PM


All times are GMT +5.5. The time now is 02:21 AM.