Oracle sql result to DBF file export
I would like to export data from a Oracle table into *.dbf file (like excel) through PL/SQL scripts. Are there any codes available? ...
dbf
ACT! - Export or Read an ACT table?
I need a copy of the Groups/Companies Contact List. How can Export or read it from another? I found one large dbf file but when opening in excel first few column come in garbled. ...
Deleted some Oracle DBF files by mistake - how can I tell Oracle XE to forget about them?
So I accidently deleted some DBF files (only ones specfic to my tablespaces), fortunately I was only just about to start loading data in so have lost nothing, except now can't re-create the tablespaces. If I run: select name from v$datafile; The results include the DBF files that I deleted. I attempted to run a command I found on th...
Search in DBF file using .idx file
I have a DBF file and a index file. I want to read index file and search records satisfy some condition. (for example: search records which its StudentName begin with "A" by using Student.DBF and StudentName.idx) How do I do this programmatically? ...
how to import data from DBF to SQL using SQL script?
I am trying to import data from DBF file to SQL table using the following command - select * from openrowset('MSDASQL', 'Driver={Microsoft dBase Driver (*.dbf)};DBQ=E:\data\;', 'select * from E:\data\a.dbf') But it is failing saying OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC dBase Dr...
Read/Write xBASE (DBASE 3-5 /DBF) files
Is there any good library for reading / writing DBF files in java or any other language ? ...
Reading DBF with VFPOLEDB driver problem.
I am using VFPOLEDB driver to read DBF files and I keep getting this error and I am not sure why and how to fix the problem: The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value. Here is the c...
Sorting a table physically in Delphi
Delphi does not seem to like multi-field indexes. How do I physically sort a a table so that I wind up with a table that has the rows in the desired order? Example: mytable.dbf Field Field-Name Field-Type Size 0 Payer Character 35 1 Payee Character 35 2 PayDate Date 3 Amount ...
Python: Fast querying in a big dbf (xbase) file
Hi all, I have a big DBF file (~700MB). I'd like to select only a few lines from it using a python script. I've seen that dbfpy is a nice module that allows to open this type of database, but for now I haven't found any querying capability. Iterating through all the elements from python is simply too slow. Can I do what I want from py...
how to open .d01 foxpro file
hey all, I am building a basic POS app for my cousin's pharmacy store so that he can dump the software he is currently using and save on license cost.All the medicines name which he has painfully entered into the software have been stored in a file with .d01 extension. What i want is a way to read the contents of the .d01 file programmat...
DBF to sql Converter
is there any free converter for DBF to Mysql? ...
Read empty values as empty and not as default values
Hi, How to read the empty values from the "dbf" file in C#. Currently while reading the dbf files, the empty values in the file are automatically getting converted to default values. Like empty decimal field is converted to "0.000". Can someone please help in way to read the empty fields as they are and not as default values. ...
How can I read a DBF file with incorrectly defined column data types using ADO.NET?
I have a several DBF files generated by a third party that I need to be able to query. I am having trouble because all of the column types have been defined as characters, but the data within some of these fields actually contain binary data. If I try to read these fields using an OleDbDataReader as anything other than a string or chara...
Visual foxpro DBF update using php
I am using php to update some tables under VFP 9.0 using ADO COM. I am able to select and update the DBF until i specify any Where clause. The moment i add a where clause to the query, it simply returns or updates 0 rows. $conn = new COM("ADODB.Connection"); $conn->Open('Provider=VFPOLEDB.1;Data Source="C:\\testDB.dbc";'); $query = "...
How do I replicate a table to all nodes in a DB2 DPF instance?
I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node? ...
How can i preserve column order in a .dbf table created in c#?
Hi I am trying to create a .dbf table using visual c# because i need it to import data to another application. For that purpose I need the column order to be exactly right otherwise that application won't accept the table. It's been working fine so far, but recently I had to make some changes to the structure of the table, and I have ad...
How to go from DBF files to SQL Server 2008?
I have an application that uses DBF files and I need to import them to SQL Server 2008. However, I also need to modify some of the data along the way and some columns will be added to tables while others will be deprecated. So far I'm using DBF -> Access -> MS Migration Assistant -> SQL Server 2008. But I think that there has to be a be...
Querying DBF file with System.Data.Odbc.OdbcConnection when file path/name has space
I'm trying to query a DBF file using System.Data.Odbc.OdbcConnection. It works correctly when the file doesn't have a space in it, but I get the following error "Error opening DBF File: ERROR [42000][Microsoft][ODBC dBase Driver]Syntax error in FROM clause" if the file path or name has a space in it. I'm using the following code: oConn...
How to store unicode data in a format that doesn't support utf-8
Okay, here's yet another character encoding question, demonstrating my ignorance of all things Unicode. I am reading data out of Microsoft Excel .xls files, and storing it in ESRI shapefiles .shp. For versions of Excel > 5.0, text in excel files is stored as Unicode. However, Unicode (and specifically UTF-8 support for shapefiles is i...
Error executing update over OLEDB from C#
I am using OLEDB to Update data in .dbf database from c#. I get Error: System.Data.OleDb.OleDbException {"Undefined function 'replace' in expression."} on ExecuteNonQuery. How can I make this work with least changes, i need to replace double quotes with single quotes in many files, so i have to automate this process. Should I try ODBC...