LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default database query to upload a dbf file

DEAR ALL THIS IS SECOND POST

-------------------------------------------------------------------
SEPTEMBER 17
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Build a query from a web-based database or a PDF file. Damian Excel Discussion (Misc queries) 0 October 26th 09 01:53 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
upload file name choice[_2_] Excel Programming 3 March 25th 05 10:38 PM
how-to use Excel to upload records to a MySQL database? chris Excel Programming 3 November 15th 04 01:43 PM
Upload Excel data into online database DH[_3_] Excel Programming 1 September 30th 03 12:57 AM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"