hELP

[MOUNKARA Yakoubou]

Hello!I would like to know how to connect access to spss through odbc.

--
MOUNKARA Yakoubou
Cell:[phone]
      [phone]
bur Tel: [phone]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Terry Reardon]

Try something like this..
===================================
 GET DATA /TYPE=ODBC /CONNECT=
'DSN=MS Access Database;DBQ=C:\YourDB.MDB;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;'
 /SQL = " SELECT ID,Num,Count FROM Widgets"

/ASSUMEDSTRWIDTH=255 .

CACHE.
EXECUTE.
============================
>>> MOUNKARA Yakoubou <[hidden email]> 2008.10.15 10:01:11 am >>>

Hello!I would like to know how to connect access to spss through odbc.

--
MOUNKARA Yakoubou
Cell:[phone]
      [phone]
bur Tel: [phone]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except
the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Roberts, Michael]

Hi,

You may need to set up your ODBC drivers first.  Depending upon your OS
(Win 95, 98, etc.), you will need to go into the administrative tools
and then set up the appropriate driver in the ODBC data source
administrator by adding it in.


HTH

Mike

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
MOUNKARA Yakoubou
Sent: Wednesday, October 15, 2008 9:01 AM
To: [hidden email]
Subject: hELP

Hello!I would like to know how to connect access to spss through odbc.

--
MOUNKARA Yakoubou
Cell:[phone]
      [phone]
bur Tel: [phone]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD