x Want to participate? Join the group to interact
  • Replies 4 replies
  • Subscribers 119 subscribers
  • Views 1429 views
  • Users 0 members are here
Browse Forums
Announcements
270
topics
260
replies
Databases and Operating Systems
761
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
414
replies
BellScott

ODBC Driver for Excel with xlsx files

Posted By

Using Sage 2021, seems the ODBC driver for excel only support .xls files.    When attempting to connect to a .xlsx, get SqlState error S1000 that the table is not in the expected format

Any way to use the driver with xlsx?

Parents Reply Children
  • in reply to Jay Converse Acumen

    Thanks Jay, is there a way around it?  From the Connector perspective, looks like Sage hasn't updated to ODBC driver in a long time.  I did try File/USER DSN, which works but has limitation that it uses a drive letter not UNC.     Unfortunately, in my environment I can't edit the registry to try and put in a UNC in the registry key.  Without UNC can't reliably schedule a report or have someone else do it.   

  • in reply to BellScott

    Sorry, I don't have any ideas.  I haven't use Excel ODBC in 20 years, it's never been necessary in my Sage integrations.

*Community Hub is the new name for Sage City