Richard,

I believe your problem lies here:

OUTTABLE="I:\off97pro.sr2\Office\MSACCESS.EXE u:office documents\db6.mdb";

the OUTTABLE line should only contain the reference to table in the MDB you want to load to, so in this case should read as

OUTTABLE="table1"

you will also need the

DATABASE="u:office documents\db6.mdb" line as well

so, something along the lines of:

PROC EXPORT data=list OUTTABLE="table1" DBMS=ACCESS97 REPLACE; DATABASE="u:office documents\db6.mdb"; RUN;

should work!

Richard.

On Thu, 17 May 2001 14:09:04 +0200, Louis Broekhuijsen <louis.broekhuijsen@CMG.NL> wrote:

>Who can help Richard further? >-----Original Message----- >From: Richard.Simhon@cornhill.co.uk >[mailto:Richard.Simhon@cornhill.co.uk] >Sent: donderdag 17 mei 2001 09:12 >To: louis.broekhuijsen@cmg.nl >Subject: RE: SAS====>>Access via ODBC > > >Louis, > >Yes I have tried DBMS=ACCESS and also DBMS=ACCESS97 bur I get the following >message in the log > >ERROR: DBMS type ACCESS97 not valid for export. > >Richard Simhon >Business Analyst >Allianz Cornhill >Tel 01483 55 2628 > >> -----Original Message----- >> From: Louis Broekhuijsen [SMTP:louis.broekhuijsen@cmg.nl] >> Sent: 17 May 2001 07:26 >> To: Richard.Simhon@cornhill.co.uk >> Subject: RE: SAS====>>Access via ODBC >> >> Dear Richard, >> >> It certainly does. The "Please use the DBMS= option." means that you have >> to >> use the DBMS= option as mentioned in the syntax. Have you tried >> DBMS=ACCESS >> yet? >> >> Kind regards, >> >> Louis Broekhuijsen >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> CMG Trade, Transport & Industry B.V. Divisie Systems Development >> Division Information Management (RTIM1) >> PO Box 8566, 3009 AN Rotterdam, The Netherlands >> E-mail: Louis.Broekhuijsen@CMG.NL >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> The Information contained in this email and its attachments is >> confidential >> and may be legally privileged. It is intended solely for the use of the >> individual or entity to whom it is addressed and others authorised to >> receive it. If you are not the intended recipient you are hereby notified >> that any disclosure, copying, distribution or taking any actions in >> reliance >> of the contents of this email and any attachments is strictly prohibited >> and >> may be unlawful. CMG is neither liable for the proper and complete >> transmission of the information contained in this email and any >> attachments >> nor for any delay in its receipt. If received in error, please contact CMG >> on +31 (0)020 50 33 000 quoting the name of the sender and the addressee >> and then delete it from your system. Please note that CMG does not accept >> any responsibility for viruses and it is your responsibility to scan the >> email and attachments (if any). No contracts may be concluded on behalf of >> CMG by means of email communications. >> >> -----Original Message----- >> From: Richard.Simhon@cornhill.co.uk >> [ mailto:Richard.Simhon@cornhill.co.uk >> <mailto:Richard.Simhon@cornhill.co.uk> ] >> Sent: woensdag 16 mei 2001 17:56 >> To: louis.broekhuijsen@cmg.nl >> Subject: RE: SAS====>>Access via ODBC >> >> >> Louis, >> >> Thanks for that information. I have had an attempt at using proc export >> but >> without much success. Would it be because I do not have SAS/ACCESS? >> I geht the following code as follows... >> >> PROC EXPORT DATA=list >> /*OUTfile="I:\off97pro.sr2\Office\MSACCESS.EXE" */ >> OUTTABLE="I:\off97pro.sr2\Office\MSACCESS.EXE u:office documents\db6.mdb"; >> DBMS=ACCESS97 ; >> >> and in the log a message as follows >> >> 6303 >> 6304 PROC EXPORT DATA=list >> 6305 /*OUTfile="I:\off97pro.sr2\Office\MSACCESS.EXE" */ >> 6306 OUTTABLE="I:\off97pro.sr2\Office\MSACCESS.EXE u:office >> documents\db6.mdb"; >> >> ERROR: Unable to determine datasource type. Please use the DBMS= option. >> NOTE: The SAS System stopped processing this step because of errors. >> NOTE: PROCEDURE EXPORT used: >> real time 0.01 seconds >> cpu time 0.01 seconds >> >> Does this mean anything to you? >> >> Richard Simhon >> Business Analyst >> Allianz Cornhill >> Tel 01483 55 2628 >> >> > -----Original Message----- >> > From:Louis Broekhuijsen [SMTP:louis.broekhuijsen@cmg.nl] >> > Sent:16 May 2001 15:44 >> > To: 'SAS-L@AKH-WIEN.AC.AT' >> > Cc: 'Richard.Simhon@CORNHILL.CO.UK' >> > Subject: RE: SAS====>>Access via ODBC >> > >> > Dear Richard, >> > >> > Don't you want to use proc export? >> > >> > PROC EXPORT >> > DATA=<libref.>SAS-data-set >> > OUT="filename" | OUTTABLE="tablename" >> > <<DBMS=identifier> <><REPLACE>> ; >> > >> > Kind regards, >> > >> > Louis Broekhuijsen >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> > CMG Trade, Transport & Industry B.V. Divisie Systems Development >> > Division Information Management (RTIM1) >> > PO Box 8566, 3009 AN Rotterdam, The Netherlands >> > E-mail: Louis.Broekhuijsen@CMG.NL >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> > The Information contained in this email and its attachments is >> > confidential >> > and may be legally privileged. It is intended solely for the use of the >> > individual or entity to whom it is addressed and others authorised to >> > receive it. If you are not the intended recipient you are hereby >> notified >> > that any disclosure, copying, distribution or taking any actions in >> > reliance >> > of the contents of this email and any attachments is strictly prohibited >> > and >> > may be unlawful. CMG is neither liable for the proper and complete >> > transmission of the information contained in this email and any >> > attachments >> > nor for any delay in its receipt. If received in error, please contact >> CMG >> > on +31 (0)020 50 33 000 quoting the name of the sender and the >> addressee >> > and then delete it from your system. Please note that CMG does not >> accept >> > any responsibility for viruses and it is your responsibility to scan the >> > email and attachments (if any). No contracts may be concluded on behalf >> of >> > CMG by means of email communications. >> > >> > >> > -----Original Message----- >> > From: richard Simhon [ mailto:Richard.Simhon@CORNHILL.CO.UK >> <mailto:Richard.Simhon@CORNHILL.CO.UK> >> > < mailto:Richard.Simhon@CORNHILL.CO.UK >> <mailto:Richard.Simhon@CORNHILL.CO.UK> > ] >> > Sent: woensdag 16 mei 2001 13:17 >> > To: SAS-L@AKH-WIEN.AC.AT >> > Subject: SAS====>>Access via ODBC >> > >> > >> > SAS-lers, >> > >> > Has anyone had any experience of using somekind of macro either in excel >> > or >> > ms access that SAS triggers to pull in sas datasets into access using >> > ODBC. >> > I am looking of automating this process rather than doing it manually? >> > >> > In essence it could be that SAS triggers a MS Access macro to pull in >> the >> > data sets or if this is not possible then to trigger from SAS an Excel >> > macro >> > which then triggers Access to pull in the SAS data sets >> > >> > Working with v8.1 on windows NT >> > >> > Thanks in advance >> > >> > Richard Simhon >> > Business Analyst >> > Allianz Cornhill >> > Tel 01483 55 2628 >> > >> > >> > >> > ********************************************************************** >> > Copyright in this message and any attachments remains with us. It is >> > confidential and may be legally privileged. If this message is not >> > intended for you it must not be read, copied or used by you or >> > disclosed to anyone else. Please advise the sender immediately if >> > you have received this message in error. >> > >> > Although this message and any attachments are believed to be free of >> > any virus or other defect that might affect any computer system into >> > which it is received and opened it is the responsibility of the >> > recipient to ensure that it is virus free and no responsibility >> > is accepted by Cornhill Insurance PLC for any loss or damage in any >> > way arising from its use. >> > >> > Cornhill Insurance Plc, Registered in England number 84638, >> > Registered Office 32 Cornhill, London EC3V 3LJ. >> > >> > Regulated by the Personal Investment Authority for life and pensions >> only. >> > Member of the General Insurance Standards Council for direct general >> > insurance only. >> > ********************************************************************** >> > >> >> >> ********************************************************************** >> Copyright in this message and any attachments remains with us. It is >> confidential and may be legally privileged. If this message is not >> intended for you it must not be read, copied or used by you or >> disclosed to anyone else. Please advise the sender immediately if >> you have received this message in error. >> >> Although this message and any attachments are believed to be free of >> any virus or other defect that might affect any computer system into >> which it is received and opened it is the responsibility of the >> recipient to ensure that it is virus free and no responsibility >> is accepted by Cornhill Insurance PLC for any loss or damage in any >> way arising from its use. >> >> Cornhill Insurance Plc, Registered in England number 84638, >> Registered Office 32 Cornhill, London EC3V 3LJ. >> >> Regulated by the Personal Investment Authority for life and pensions only. >> Member of the General Insurance Standards Council for direct general >> insurance only. >> ********************************************************************** > > >********************************************************************** >Copyright in this message and any attachments remains with us. It is >confidential and may be legally privileged. If this message is not >intended for you it must not be read, copied or used by you or >disclosed to anyone else. Please advise the sender immediately if >you have received this message in error. > >Although this message and any attachments are believed to be free of >any virus or other defect that might affect any computer system into >which it is received and opened it is the responsibility of the >recipient to ensure that it is virus free and no responsibility >is accepted by Cornhill Insurance PLC for any loss or damage in any >way arising from its use. > >Cornhill Insurance Plc, Registered in England number 84638, >Registered Office 32 Cornhill, London EC3V 3LJ. > >Regulated by the Personal Investment Authority for life and pensions only. >Member of the General Insurance Standards Council for direct general >insurance only. >**********************************************************************