At 03:46 PM 1/6/2002 -0800, Fred Antrobus wrote:
>
>I was looking for suggestions on the best approach
Fred,
Option A.
You can take advantage of new LOAD AS CSV option using
The Glorious R:BASE 2000 (version 6.5++) for Windows!
Steps:
01. Save MS Excel spreadsheet without header information
as CSV.
02. LOAD the CSV file into a TEMPORARY table and do all
your data validation, etc.
03. UPDATE you table(s) accordingly.
Option B:
01. Using Oterro (ver 2.5), create a DSN for R:BASE Database
02. Using Query option, update R:BASE Table(s) using MS Excel
If you need more details and steps, let me know.
Good Luck!
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
