I am using SATTACH to attach Access tables. The tables I need to attach have
a large number of columns with names that are not R:Base valid as they
contain spaces and characters such as "(" and "%" , the tables have very few
records and I need only a couple of columns per table. I was hoping to be
able to do something like:SATTACH 'Scenario Description' AS WTCostData USING 'Acces Col1%', + 'Access Col(2)' ALIAS RBCol1, RBCol2 However, when I do this, the command assigns the alias to the first 2 columns and then prompts for aliases for the rest of the columns. Since some of the tables might have a large number of columns with very long names, the command to do this SATTACH would be huge. I finally found (by accident) that if you assign the same Alias to all the columns, the software adds a sequential number to the duplicate aliases: SATTACH 'Scenario Description' AS WTCostData USING ALL + ALIAS SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol,SDCol The resulting R:Base table has columns labeled: SDCol, SDCol_1, SDCol_2, SDCol_3, SDCol_4, SDCol_5, SDCol_6, SDCol_7, SDCol_8, SDCol_9 Which is a big improvement in the coding. However, I would like to be able to attach what would essentially be a view of the server tables with only a few columns. I have the restriction that I cannot modify the access database or add a view there....is there a way to do this? Javier, Javier Valencia, PE Sr. Project Manager Universal Asset Management, L.L.C. 801 Westchester Ave. Harrisonville, MO 64701 Phone: 816-887-4011 Fax: 816-887-1960 Cell: 913-915-3137 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
