Now there are two steps:
1. Using VBA to create a table, data source is from another excel file. I wrote the VBA program.
2. Run SAS program (SAS application) to load data into database. Someone else wrote SAS program.
Question: How to call SAS program within Excel? So that I don't have to open SAS app.
Thanks.
Last edited by VAer; 10-05-2023 at 02:37 PM.
dont need step 1 if you can import data from SAS.
do you have an ODBC for SAS? This allows you to connect to the SAS table, then the table can reside in Access.
or
use the connection code to connect into Access or Excel.
something like:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks