Import an excel or access (xlsx or accdb) in a server 64b

Reply
New Contributor
Posts: 2

Import an excel or access (xlsx or accdb) in a server 64b

Good morning,

I'm trying to import a file to a 64b server and I can't achive it. I use SAS 9.2.

My server properties (RSUBMIT; PROC SETINIT NOALIAS;RUN; ENDRSUBMIT;) are:

24   RSUBMIT;

NOTE: Remote submit to "SERVER NAME" commencing.

336  PROC SETINIT NOALIAS;RUN;

NOTE: PROCEDURE SETINIT used (Total process time):

      real time           0.02 seconds

      user cpu time       0.00 seconds

      system cpu time     0.00 seconds

      Memory                            330k

      OS Memory                         4644k

      Timestamp            10/22/2013  12:03:13 PM

      Page Faults                       10

      Page Reclaims                     80

      Page Swaps                        0

      Voluntary Context Switches        0

      Involuntary Context Switches      0

      Block Input Operations            0

      Block Output Operations           0

Original site validation data

Site name:    'XXXXXX'.

Site number:  XXXXXX.

CPU A: Model name='' model number='' serial='+12'.

Expiration:   31DEC2013.

Grace Period:  62 days (ending 03MAR2014).

Warning Period: 31 days (ending 03APR2014).

System birthday:   15MAY2013.

Operating System:   AIX 64  .

Product expiration dates:

---Base Product                                                            31DEC2013 (CPU A)

---SAS/STAT                                                                31DEC2013 (CPU A)

---SAS/GRAPH                                                               31DEC2013 (CPU A)

---SAS/ETS                                                                 31DEC2013 (CPU A)

---SAS/IML                                                                 31DEC2013 (CPU A)

---SAS/SHARE                                                               31DEC2013 (CPU A)

---SAS/CONNECT                                                             31DEC2013 (CPU A)

---SAS/SHARE*NET                                                           31DEC2013 (CPU A)

---SAS OLAP Server                                                         31DEC2013 (CPU A)

---SAS Enterprise Miner                                                    31DEC2013 (CPU A)

---MDDB Server common products                                             31DEC2013 (CPU A)

---SAS Integration Technologies                                            31DEC2013 (CPU A)

---SAS Strategic Performance Management                                    31DEC2013 (CPU A)

---Enterprise Miner Server                                                 31DEC2013 (CPU A)

---Enterprise Miner Thin Client                                            31DEC2013 (CPU A)

---SAS Solutions Server Components                                         31DEC2013 (CPU A)

---SAS/ACCESS Interface to DB2                                             31DEC2013 (CPU A)

---SAS/ACCESS Interface to ORACLE                                          31DEC2013 (CPU A)

---SAS/ACCESS Interface to PC Files                                        31DEC2013 (CPU A)

---SAS/ACCESS Interface to Teradata                                        31DEC2013 (CPU A)

---SAS/ACCESS Interface to MYSQL                                           31DEC2013 (CPU A)

---SAS Metadata Bridge for IBM WebSphere DataStage                         31DEC2013 (CPU A)

---SAS Metadata Bridge for Microsoft Excel                                 31DEC2013 (CPU A)

---SAS Metadata Bridge for Oracle                                          31DEC2013 (CPU A)

---SAS Metadata Bridges for General Industry Standards                     31DEC2013 (CPU A)

---SAS Stat Studio                                                         31DEC2013 (CPU A)

---SAS Workspace Server for Local Access                                   31DEC2013 (CPU A)

---SAS Workspace Server for Enterprise Access                              31DEC2013 (CPU A)

---SAS Table Server                                                        31DEC2013 (CPU A)

NOTE: Remote submit to "SERVER NAME" complete.

I tried some solutions to import the files but I didn't find the solution. I've only found a solution that consists in create a libname in a local directory and adress to a server directory and import file locally. But with this option, I'm using the performance of my pc and I want to use the server performance...

The solutions and errors that I tried are:

/***** CONNECT TO SERVER ******/

options comamid=tcp;

signon SERVERNAME user=_PROMPT_ password=_PROMPT_;

/***** Server Libraries ******/

rsubmit;

  libname CR '/SERVER DIRECTORY';

endrsubmit;

/******* Local Library *******/

libname CR server= SERVER slibref= CR ;

/******* OPTIONS THAT I TRIED *********/

rsubmit;

  /********** 1 LIBNAME WITH ACCESS ENGINE --> DOESN'T WORK BECAUSE DOESN'T RECOGNIIZE THE ENGINE ACCESS OR EXCEL (MAYBE THE PROBLEM IS THE 64BITS SERVER *********/

libname accdb access '/SERVER DIRECTORY/FILE.accdb

';

  /********** 2 LIBNAME WITH ODBC --> THE SERVER DOESN'T HAVE THE ODBC OPTION ********/

  libname myacc odbc required=

     "Driver={Microsoft Access Driver (*.mdb, *.accdb)};

    DBQ=/SERVER DIRECTORY/FILE.accdb";

  /********** 3 IMPORT WITH EXCEL --> THE SERVER DOESN'T RECOGNIZE EXCEL OR ACCESS BECAUSE THESE OPTIONS ARE NOT VALID FOR 64BITS SERVER *******/

  proc import out=CR.T10

  datafile= '/SERVER DIRECTORY/FILE.xlsx'

  dbms=excel replace;

  sheet='DATOS';

  getnames=yes;

  mixed=no;

  run;

  /********** 4 IMPORT WITH EXCELCS --> THE PROBLEM IS THE CONNECTION WITH THE SERVER - ERROR: FAILED TO CONNECT TO SERVER "SERVER NAME" *******/

  proc import out=CR.T10

  datafile= '/SERVER DIRECTORY/FILE.xlsx'

  dbms=excelCS replace;

  sheet='DATOS';

  server= 'SERVER NAME';

  run;

endrsubmit;

¿How can I import an access or excel file in this server? ¿Any ideas?

Many thanks for all responses.

David H.

New Contributor
Posts: 2

Re: Import an excel or access (xlsx or accdb) in a server 64b

Posted in reply to davidpijo2
Ask a Question
Discussion stats
  • 1 reply
  • 1005 views
  • 0 likes
  • 1 in conversation