ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   upload data from a dbf file (https://www.excelbanter.com/excel-programming/340365-upload-data-dbf-file.html)

sajay

upload data from a dbf file
 

Hi every 1

I want to upload data from two dbf files.
One file is the names
and the other is theire records with corresponding unique id
I want to show the records with name (not unique id) in one worksheet.


yours
sajay

(I don't know what this dbf means. some say its 'dbase file', some say
it is 'foxpro file'. i really don't know the exact data source)


Vacation's Over

upload data from a dbf file
 
Google DBF file extension =
http://www.seniormag.com/compcorner/...t/biglistd.htm

You need more information

"sajay" wrote:


Hi every 1

I want to upload data from two dbf files.
One file is the names
and the other is theire records with corresponding unique id
I want to show the records with name (not unique id) in one worksheet.


yours
sajay

(I don't know what this dbf means. some say its 'dbase file', some say
it is 'foxpro file'. i really don't know the exact data source)



sajay

upload data from a dbf file
 
hi vacations

Hi every 1


I want to upload data from two dbf files.
One file is the names
and the other is theire records with corresponding unique id
I want to show the records with name (not unique id) in one worksheet.

My first file (dbf) has the following fields
CLIENT_ID,CLIENT_NAME,CONTACT_PERSON, TYPE

Next file (dbf) has following fields CLIENT_ID, BILL_DATE,BILL_AMOUNT,
WORK,WORK_DONE_BY.

I want to list these datas in to a Excel Sheet listing BILL DATE,
CLIENT NAME, BILL AMOUNT

instead of secondfile's CLIENT ID i want to list first file's
CLIENT_NAME

PLS help.



All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com