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: [email protected] [mailto:[email protected]] Im Auftrag von Isabelle Deltour
Gesendet: Mittwoch, 11. November 2009 13:26
An: [email protected]
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: [email protected] [mailto:[email protected]] On Behalf Of Kaulisch, Marc
Sent: Wednesday, November 11, 2009 12:14 PM
To: [email protected]
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: [email protected]
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/
