Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to get my tables (Sheets) listed with MS Excel as source ?

April 26, 2017Excel MS sheets source tables

0

Posted

How to get my tables (Sheets) listed with MS Excel as source ?

1 Answer

0

Posted

To get more tables (Sheets) listed with MS Excel as source go into Options -> More Options -> Misc Tab, Then activate ‘Extract system tables’. More tables will then be listed. Note that when working with Excel tables (Sheets) with this option activated the first row will be used for fields names, so verify that your Excel file meet that requirement. This option is experimental and have not been tested on other types of sources yet, so strange error messages can occur when this option is enabled and used on other types of sources. If you have problems connecting to your Excel file (Get the list of tables for example) disable the Jet provider in Options -> More Options -> Misc Tab.