Is the sign ' in the data not a just the single quotation mark but
really the single left quotation mark that is used in stata to mark
local macros?
I have faced similar problems with data translated from SPSS in which
the "left" single quotation was used in variable labels.
Am Mittwoch, den 11.11.2009, 14:21 +0100 schrieb Kaulisch, Marc:
> 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/
*
* 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/
