Re: Questions on data exporting

Hello,

look at http://www.scalabium.com/ for "SMExport" this should do it (and more).

You can export data of a table to entirely any Dataformat with really
small affort. Just look at it ;) it's really good.

	Sincerely

			Oliver Katins

Am Tue, 26 Jul 2005 13:49:20 -0700 schrieb E.P. <epergola@xxxxxxxxxxxxxx>:

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









--
Erstellt mit M2, Operas revolutionärem E-Mail-Modul: http://www.opera.com/m2/
.

Quantcast