-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Franco Fornari wrote:
> I don't need to modify anything. I'd only wish to be able to build
> queries based on more than one sheet/table. At present this isn't
> allowed in Base, if the database backend is a worksheet.
I understand. What I'm saying is that maybe there is an easy way to get
the data into a database instead of using a spreadsheet.
On Linux, you could have a Perl script that would:
1. Verify that the CSV file exists.
2. Open a connection to the DB.
3. Issue an SQL DELETE statement to delete the existing data.
4. Read the CSV file line by line,
a. Parse the line and place the values into an array.
b. Create and execute an SQL INSERT statement to create a
record from the array elements.
5. Notify you of the number of lines processed and the number of records
successfully inserted into the DB.
After writing such a script, your actions would be:
1. Download the data, saving it to a specified location with a specified
name.
2. Run the script.
This is simpler than a spreadsheet import, but only if your environment
supports a scripted connection to your DB.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Anthony E. Greene <mailto:[EMAIL PROTECTED]> 0x6C94239D
iD8DBQFE5HNdpCpg3WyUI50RAtZmAJ9ZIfj/gTjqC8/cEyTOtStz9E1ofgCbBCfB
5YwXpSpgMNx1zvJ0/H9yl+w=
=Bluu
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
