Dear all, I need to convert a very large file from DBF format to CSV format. I have tried Microsoft Excel to do the job, but the problem is that I cannot see more than 65500 registers when I open and export the file. Microsoft Access couldn't open the file, too. I have found on google some shareware tools, searching for "DBF to CSV". ...
Hi, I've been trying to work out how to connect to an ESRI shape file (which I think is a DBase table file) through NHibernate but haven't had any luck with anything I've tried. Currently, my config's looking like this: <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property> <!--<property name="...
Hi, I'm trying to convert an XML file to DBF. Right now I do this manually, opening the XML file in Excel 2003 and saving it as a DBF 4 file type. This is a boring and time consuming process, made worse by the fact that neither Office 2007, nor Office 2008 for Mac allow saving as DBF any more. I'd like a way to automate this, if possib...
As the title suggest, I was wondering if there is a Python module that can access an Advantage Database Server (Sybase) files such as ADT and DBF. I have searched the web and couldn't find what I'm looking for this is why I wanted to ask it here. ...
I have only found trial versions of these converters. Does anyone know a free one? Any of the following target formats will do: CSV, MDB, SQL, XLS ...
Hey all, really bashing my head against a keyboard here, any information or pointing in the right direction would be fantastic. I have a set of .DBF files with .MDX indexes. They're supposed to be dBASE version 7, but the Borland BDE only connects to 5.0 reliably from what I've found. I can get connected using the IV and 5.0 connection...
I have a large collection of DBF files (about 1100 of them) that I need to analyze for a client. Each file contains a single table. I need to perform a query on each table, copy the results into one large results table (which will hold the results from all files), and then move on to the next DBF file. At the end I need to save the resul...
Does anyone know how to import .dbf file into MS ACcess 2007? ...
I have huge problem: I have lots of .dbf files(~50000) and I need to import them into Oracle database. I open conncection like this: OleDbConnection oConn = new OleDbConnection(); OleDbCommand oCmd = new OleDbCommand(); oConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + directory + ";Extended Propertie...
I need to extract data from a .dbf file and transform it into xml. I wrote a routine that does it just fine. However now we are encountering very large .dbf files - like 2GB +. And this code throws an OutOfMemoryException on those files. Public Function GetData() As DataTable Dim dt As New DataTable(Name) Dim sqlcommand As St...
Is it possible to specify which character encoding should be used by OLEDB when querying a DBF file? A possible work-around would be to encode the query string before the OLEDB call to the DBF file's character encoding and then encode all the results when they are returned. This will work but it would be nice if OLEDB or possibly ADO.N...
Hello Experts, I received a dbf file from one of our vendors. I need to export that data into one of the tables in SQL Server 2005. When I try to import data by going to Tasks->Import I dont get an option to select dbf file. I need your help finding an easy way of accomplishing this task Thanks ...
Hi all, I have to take a bunch of columnar text files and integrate them into a single big dbf file, possibly with an intermediate step in a sqlite database. DBF is the basic file of databases, hence the weird request. Does anybody know a command line tool for going between text and dbf? Or a sqlite way to attach dbf's would work in ...
Hi, any one knows if there is a activex dll that can create VFP DBF files? I mean im writing app with 1C:Enterprise 8.2 language, and i need to export some datas into VFP DBF. And i can only use activex dlls in this language. Would be perfect to get free dll, but i can pay also if there is anything good. ...
Hi, I am working on a project in Visual Studio 2008 (in vb.net). The app needs to import data from a Visual FoxPro database (dbc file). Do not ask why FoxPro. It needs to be vfp and the database is updated daily by another application; therefore, I cannot use any other database format. I connect to the database through OleDb FoxPro dri...
How to generate DBF files with delphi? More information: I need a portable Database to run in a pendrive I don't know if DBF is the better soluttion. I like MySql but is hard to find a portable version I am working with XML at this time but I don't know how to make a Query. ...
I have to convert .DBF and .FPT files from Visual FoxPro to MySQL. Right now my script works for .DBF files, it opens and reads them with dbase_open() and dbase_get_record_with_names() and then executes the MySQL INSERT commands. However, some fields of these .DBF files are of type MEMO and therefore stored in a separate files ending in...
I need some large dbf files. It is not very important what is inside. On classes I have assignment to use SAS Enterprise Miner to explore and mine some data, just to give axample. I cannot ude sample data from sas, I need another one with large amount of records (e.g. 5k-10k) Where can I find those? Because google is useless in this cas...
We're trying to insert data into a clipper database file (DBF file with NTX index file). For a variety of reasons, we cannot change the database format. We are currently seeing two issues: With our existing code, we are not able to update or utilize the NTX index file (I believe). We would like to be able to do this. Do you know of...
I've googled and searched through Matlab Central, but cannot find any way to open DBF files directly in Matlab. There are some references to DBFREAD function in TMW File Exchange, but it's not available anymore. Is it really a problem? I do have Database toolbox, but could not find dbf support there. I don't want to use Excel or othe...