lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
*.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
I use the above string to connect to Excel files. It normally does fine
with xls and xlsx. Today I have a customer that has Office 2010
installed and it does not work. It returns a -1 which doesn't tell me much.
Do I need to change the connection string for 2010?
--
Jeff
Jeff Johnson
jeff@dcsoftware.com
(623) 582-0323
Please reply to jeff@san-dc.com!
Visit our forum at www.san-dc.com/forum
Register and join in the discussion
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/54651911.50903@dcsoftware.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.
Use AERROR() to see what the error is.
Fred
On Thu, Nov 13, 2014 at 1:48 PM, Jeff Johnson <jeff@dcsoftware.com> wrote:
> lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
> *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
>
> I use the above string to connect to Excel files. It normally does fine
> with xls and xlsx. Today I have a customer that has Office 2010 installed
> and it does not work. It returns a -1 which doesn't tell me much.
>
> Do I need to change the connection string for 2010?
>
>
> --
> Jeff
>
> Jeff Johnson
> jeff@dcsoftware.com
> (623) 582-0323
>
> Please reply to jeff@san-dc.com!
>
> Visit our forum at www.san-dc.com/forum
> Register and join in the discussion
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksoXimYyaZgDQk-wd4oYtqY48owuYgXpOatncXXwYSipsg@mail.gmail.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.
Wow, you're just having all sorts of problems today. So sorry.
Mike
--------------------------------------------------------------------------------
From: Jeff Johnson
Sent: Thursday, November 13, 2014 1:48 PM
To: profoxtech@leafe.com
Subject: Excel Driver Not Working
lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
*.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
I use the above string to connect to Excel files. It normally does fine
with xls and xlsx. Today I have a customer that has Office 2010
installed and it does not work. It returns a -1 which doesn't tell me much.
Do I need to change the connection string for 2010?
--
Jeff
Jeff Johnson
jeff@dcsoftware.com
(623) 582-0323
Please reply to jeff@san-dc.com!
Visit our forum at www.san-dc.com/forum
Register and join in the discussion
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/E7B073DBA76F46ADBD2EE295B8E0FE00@Studio17
** 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.
On Thu, Nov 13, 2014 at 2:48 PM, Jeff Johnson <jeff@dcsoftware.com> wrote:
> lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
> *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
>
> I use the above string to connect to Excel files. It normally does fine
> with xls and xlsx. Today I have a customer that has Office 2010 installed
> and it does not work. It returns a -1 which doesn't tell me much.
>
> Do I need to change the connection string for 2010?
> ---------------
This is the only place to go to get the answer.
http://www.connectionstrings.com/excel-2010/
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMY+aL-eRNi4Ea=g81CHXWx7orWiaB26q6OT8Qg8nk1Wzmw@mail.gmail.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.
Yep, same customer. Most of their spreadsheets are .xlr which are Works
files. It's a little tiny business back east and their IT department
has their system locked down tighter than a drum. I don't have any
problem with that as long as the IT folks will work with me. Which
these are.
I thought I finally had this xlsx problem nailed down until today.
Thank goodness for Profox!
On 11/13/2014 1:54 PM, Michael Glassman wrote:
> Wow, you're just having all sorts of problems today. So sorry.
>
> Mike
>
>
> --------------------------------------------------------------------------------
>
>
>
> From: Jeff Johnson
> Sent: Thursday, November 13, 2014 1:48 PM
> To: profoxtech@leafe.com
> Subject: Excel Driver Not Working
>
>
> lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
> *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
>
> I use the above string to connect to Excel files. It normally does fine
> with xls and xlsx. Today I have a customer that has Office 2010
> installed and it does not work. It returns a -1 which doesn't tell me much.
>
> Do I need to change the connection string for 2010?
>
>
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/54651C43.1060509@san-dc.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.
I use that driver the whole time for various projects and it works fine
for both Excel 2010 and Excel 2013.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1415959141.2584741.190938741.1BB53872@webmail.messagingengine.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.
Alan, which one?
Thanks,
On 11/14/2014 2:59 AM, Alan Bourke wrote:
> I use that driver the whole time for various projects and it works fine
> for both Excel 2010 and Excel 2013.
>
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5465F4AF.10005@san-dc.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.
I've had that problem when there are more than 255 columns with data - even if blank, causing [select * from someworkbook] to fail.
Customized Business Services, LLC (928) 580-6352
Dennis Schuette Primary: dennis@cbsds.com
350 West 16th Street, Suite 309 Alternate: Schuette.dennis@gmail.com
Yuma, AZ 85364 Map it
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jeff Johnson
Sent: Thursday, November 13, 2014 1:48 PM
To: profoxtech@leafe.com
Subject: Excel Driver Not Working
lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
I use the above string to connect to Excel files. It normally does fine with xls and xlsx. Today I have a customer that has Office 2010 installed and it does not work. It returns a -1 which doesn't tell me much.
Do I need to change the connection string for 2010?
--
Jeff
Jeff Johnson
jeff@dcsoftware.com
(623) 582-0323
Please reply to jeff@san-dc.com!
Visit our forum at www.san-dc.com/forum
Register and join in the discussion
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/AE18F449479D7E4688F74460A1B958230D94CC02@DC.cbsds.local
** 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.
So are most of you saying the below parameters should work with 2010?
What about 2013?
On 11/13/2014 1:48 PM, Jeff Johnson wrote:
> lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
> *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
>
> I use the above string to connect to Excel files. It normally does
> fine with xls and xlsx. Today I have a customer that has Office 2010
> installed and it does not work. It returns a -1 which doesn't tell me
> much.
>
> Do I need to change the connection string for 2010?
>
>
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/546645CE.5000607@san-dc.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.
When you get the -1 error, use AERROR() to get the full error information
to tell you what's wrong.
Fred
On Fri, Nov 14, 2014 at 11:11 AM, Jeff Johnson <jeff@san-dc.com> wrote:
> So are most of you saying the below parameters should work with 2010?
> What about 2013?
>
>
> On 11/13/2014 1:48 PM, Jeff Johnson wrote:
>
>> lnsqlhandle = SQLSTRINGCONNECT("Driver={Microsoft Excel Driver (*.xls,
>> *.xlsx, *.xlsm, *.xlsb)}; DBQ=" + lcspreadsheet + ";")
>>
>> I use the above string to connect to Excel files. It normally does fine
>> with xls and xlsx. Today I have a customer that has Office 2010 installed
>> and it does not work. It returns a -1 which doesn't tell me much.
>>
>> Do I need to change the connection string for 2010?
>>
>>
>>
> --
> Jeff
>
> Jeff Johnson
> jeff@san-dc.com
> SanDC, Inc.
> (623) 582-0323
> SMS (602) 717-5476
> Fax 623-869-0675
>
> www.san-dc.com
> www.cremationtracker.com
> www.agentrelationshipmanager.com
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJCBksrs5qRF1MoRrV2J9WBr-edA6n=iL9EzzyQDzRCOiZ4zaw@mail.gmail.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.