Questions on data exporting

Hi

I have a customer that asked me if I can export data to
mainstream data analysis tools (e.g. Excel, MS Access, etc.) for
presentation.
The database is a FF 1.57 relational database, consisting of
120 separate files.
Question #1. is there a 3rd party software (free or inexpensive) that would
automatically
export all data to a specific format (e.g. Excel, MS Access).
Question #2. I have a hard time understanding the concept of exporting
complex relational
databases to other format, or even, say. to a text (comma delimited for
example) format for the
purpose of analizing the RAW data (to create for example, presentation
sheets).
How would the end user know the relation among the various files?
Suppose I have files (very exemplified)
A Cust. Id, Purchase Order No.
B P.O. #, with all items purchased
C Cust. Id., Name, Address, Cust. Categ. Id.
D Cust Categ Id, Description, Discount rate.
Now if the end user wants to, say, print an invoice in his own format, he
will have to know to
1. fetch the Customer name & address from file C
2. fetch the list of purchased items from file B
3 determine what discount to apply from file D.
How would he be able to extract that information from a set of exported
files (for simplicity in text format)
file A text
ID PO
0239 7890
0240 7891 ... etc.
file B text
PO ITID
7890 1267
7890 6521
7890 654 etc....
file C text
ID Name Addr Categ
0981 xyz somewhere 07
0982 abc somewhere else 02 .....
file D text
ID Desc Disc
01 VIP 20%
02 complainer -15%....
Thanks for any help
Enrico






.

Relevant Pages

  • RE: Importing data from excel spreadsheets
    ... it spits back a formatted sheet ... The format of the ... their own copy of the database, and get a piece of the formatted spreadsheet, ... Access and Excel are two different animals. ...
    (microsoft.public.access.externaldata)
  • Imported value from Access database changes when displayed in Excel
    ... another database. ... (I know, this is the Excel NG, but this question will ... to just dump the Recordset into the worksheet. ... So is this an Excel XP date format problem. ...
    (microsoft.public.excel.programming)
  • Re: DAO or ADO
    ... Load a ListBox from a Named Range in Excel using DAO ... is mdb the best database format to use in this case? ... what method should I use for calling up the database from ...
    (microsoft.public.word.vba.general)
  • Re: Time convert
    ... I use a multitude of SQL queries to get it to the format I desire, ... I open the excel sheet, I only get the date displayed but the time is ... Is there a way to query my Access database in such a way I only have ... it will have date and time in the field (since it is a date/time ...
    (comp.lang.basic.visual.database)
  • Re: Collecting data in MS Outlook
    ... In addition User Level Security is not supported in the new format. ... When I was converting my database, ... The link you showed only uses Microsoft Outlook 2007 and Microsoft Access ... Dim fdrInBox As Outlook.MAPIFolder ...
    (microsoft.public.access.security)