Using SSMS, simple as can be for now. Eventually I would build an SSIS job to do it, but if I can't SQL to read the data in SSMS then I don't know how SSIS will read it...
Thanks for checking it out for me! Lou -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Kaye Sent: Thursday, September 15, 2011 10:29 AM To: [email protected] Subject: RE: VFPOLEDB issues in SQL 2008R2 / Windows 7 You definitely need the 32 bit ODBC administrator to make sure that it's installed properly. You did see the recent post that MS is deprecating OLEDB, right? I'll see if I can try this out on my W7 dev system and let you know what happens. How are you attempting to import the data? In SSMS? TSQL script? -- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lou Syracuse Sent: Thursday, September 15, 2011 1:22 PM To: [email protected] Subject: VFPOLEDB issues in SQL 2008R2 / Windows 7 Just wondering if this is a Windows 7 thing, or a SQL 2008R2 thing, or an issue with my computer, . or something else? I'm trying to import data from a VFP database to a table in SQL2008R2. Everything is on my local Windows 7 based computer. I start the wizard in SMS and select "Microsoft OLE DB Provider for Visual FoxPro" as the data source, but I get no criteria below to enter information into. When I click on properties I get a message box that says "Unexpected Unrecoverable Error". Gee, that's an informative message. Clicking any of the buttons (Abort, Retry, Ignore) closes the wizard. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005101cc73ce$d66b8690$834293b0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
