I would open the file in EXCEL, clean it up, and save as a formatted text (space delimited) file in EXCEL. Make sure you rename it so you are not copying over the original file.
Now go into R:BASE through gateway, and import the file. Create a script so that you can import the data the same way each month. That way, you don't really need a temporary table. Just create a new one the first time, and either append onto it or replace the data each month. Good Luck. Sincerely, A. Horowitz ================================================ 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
