Can this be done ??
 

Sorry to post again, but 24 hours on with no response to my initial
post, I think it unlikely to now be read.........may I ask again with a
little more explaination.... any help appreciated.

I have 7 foxpro database files that each contains specific information
about clients. One database (personal) contains the client personal
detail whilst the other files are referenced by the unique client_ID
and contain clinical information about the 'clients'.

I would like to create a worksheet that lists all the client name /
address (
from the 'Personal' file ) and certain fields from each of the other
files. Simply put, each of the other files contain details of the
'clients' medical conditions.....asthma/heart disease/diabetes etc. I
need to pull this information together into one worksheet to show the
condition(s) each client has.....ie who has more than one condition. I
haverun MS Query but this returns only clients who meet ALL
criteria......some clients would have a blank value in some fields
where they don't have the condition, these then are not included in the
returned worksheet...........I am looking to end up with every client
listed and with blank cells if there is no data within that field value
ie no condition existing...........hope this makes
sense.......question, is this possible and how do I do it.

many thanks...........

This could be a Foxpro question about which I know nothing.

The first question in reply is can Foxpro export all of its data by way
of a .csv or .txt file?

If so, then you could open these in Excel, and correctly columnise the
entries, then use VLookup from the first (Personal) sheet to add data
from other sheets into the required columns.

Then Copy that worksheet and Paste Special, Values to a new worksheet.

There are other ways to join worksheets, but this one provides
simple-to-check processing for each step.




Mike Wrote:
Sorry to post again, but 24 hours on with no response to my initial
post, I think it unlikely to now be read.........may I ask again with
a
little more explaination.... any help appreciated.

I have 7 foxpro database files that each contains specific information
about clients. One database (personal) contains the client personal
detail whilst the other files are referenced by the unique client_ID
and contain clinical information about the 'clients'.

I would like to create a worksheet that lists all the client name /
address (
from the 'Personal' file ) and certain fields from each of the other
files. Simply put, each of the other files contain details of the
'clients' medical conditions.....asthma/heart disease/diabetes etc. I
need to pull this information together into one worksheet to show the
condition(s) each client has.....ie who has more than one condition. I
haverun MS Query but this returns only clients who meet ALL
criteria......some clients would have a blank value in some fields
where they don't have the condition, these then are not included in
the
returned worksheet...........I am looking to end up with every client
listed and with blank cells if there is no data within that field
value
ie no condition existing...........hope this makes
sense.......question, is this possible and how do I do it.

many thanks...........


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395481