Where I work, we unfortunately use the dinosaur called SAS. I have a SAS plug in for excel which allows me to ODBC in, execute SAS code, and retrieve the data set created using the copyfromrecordset statement.
Problem is this is one directional. I have a need whereby I have data in an excel sheet that i would like to take from excel and throw into a data set in SAS. in effect, I need to do the reverse of copyfromrecordset. What I am attemting is the environment SAS is in has areas (libraries) that are opportune for storing data for me to keep historical records of data i extract, therefore i really need to export the data I create in excel into one of these SAS libraries. Does anybody know of a way I can simply grab the data sitting in an excel sheet and throw it through the odbc connection to have it sit there as either a new table or append to an existing one? SQL is not an option on this one due to it being the SAS environment, though if anybody knows a way of executing code and have this code also mix in with local objects. Such as if i was to write a code that excel wil lthrow into SAS, but somehow be able to also connect to an open sheet for data. thanks in advance for any help -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe