Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: AW: RE: data to Access by odbc


From   "Kaulisch, Marc" <kaulisch@forschungsinfo.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: AW: RE: data to Access by odbc
Date   Wed, 11 Nov 2009 14:21:18 +0100

Yeah, it looks like the odbc command does not like single quotes in string variables...
If I recode single quotes in dashes it works.

But does anybody knows more about the limitations of the -odbc- command? I easily get the comment from the driver that the dataset is too large... I guess it's the driver's problem and not Stata's, or?

Marc

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Isabelle Deltour
Gesendet: Mittwoch, 11. November 2009 13:26
An: statalist@hsphsun2.harvard.edu
Betreff: st: RE: data to Access by odbc

Just a suggestion: (and I only have a very basic knowledge of german language). 

Is there not something special in the data where Stata / Access chokes?
To me it looks like the line
''Stipendium im Rahmen des Exzellenzclusters 'Topoi''' 
cannot be included in the Access table. 
If this looks plausible to you, I would have a look at the quotes first, if they are recognized properly, either by Access, Stata or the connection between the 2. If this is not the case, it could also be something to do with the line before or after ?

Hope this helps
Isabelle




-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Kaulisch, Marc
Sent: Wednesday, November 11, 2009 12:14 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: data to Access by odbc

I receive a strange error when I try to insert data from Stata into an Access (2003) database.
 
. odbc insert id epp* ep1B* ep2B*, table("1") dsn("BN_stata") create Connection Parameters: DSN=BN_stata;DBQ=Q:\10_Projekte\Profile\60_Daten\01pf\091001n\daten\BN_
> stata.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=4096;PageTimeout=5;
 
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator) in Abfrageausdruck
>  ''Stipendium im Rahmen des Exzellenzclusters 'Topoi'''.
r(682);

When I do
. odbc load, table("1")
 
I get the exported data back into Stata but there are only 46 cases instead of 2100...
 
Any kind of ideas?
 
Thanks,
 
Marc 
 

iFQ
Institut für Forschungsinformation und Qualitätssicherung Godesberger Allee 90
53175 Bonn, Germany
Tel.: *49 - 228 - 9 72 73 - 25
Fax: *49 - 228 - 9 72 73 - 49
E-mail: kaulisch@forschungsinfo.de
www.forschungsinfo.de 


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index