Importing OpenOffice Data into SPSS

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Importing OpenOffice Data into SPSS

Luca Meyer-3
Hi,

Is there someone importing directly into SPSS OpenOffice Base (*.odb)? If so
how do you do that? I have been searching for an ODBC driver but I could not
find it...

Thanks,

Luca
www.lucameyer.com

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Importing OpenOffice Data into SPSS

ViAnn Beadle
What happens if you use the Access ODBC driver? OpenOffice is supposed to be
compatible with Microsoft Office in file formats.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Luca Meyer
Sent: Wednesday, March 11, 2009 12:04 AM
To: [hidden email]
Subject: Importing OpenOffice Data into SPSS

Hi,

Is there someone importing directly into SPSS OpenOffice Base (*.odb)? If so
how do you do that? I have been searching for an ODBC driver but I could not
find it...

Thanks,

Luca
www.lucameyer.com

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Importing OpenOffice Data into SPSS

Luca Meyer-3
Unfortunately it gives me an error "SQLDriverConnect Failed". That is probably because the driver accounts for file with the extension *.mdb while the files OpenOffice are *.odb. Any other suggestion?
 
Luca

2009/3/11 ViAnn Beadle <[hidden email]>
What happens if you use the Access ODBC driver? OpenOffice is supposed to be
compatible with Microsoft Office in file formats.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Luca Meyer
Sent: Wednesday, March 11, 2009 12:04 AM
To: [hidden email]
Subject: Importing OpenOffice Data into SPSS

Hi,

Is there someone importing directly into SPSS OpenOffice Base (*.odb)? If so
how do you do that? I have been searching for an ODBC driver but I could not
find it...

Thanks,

Luca
www.lucameyer.com

=====================
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