Rookie question here: Can anyone explain why the Database Expert seems to duplicate the tables in the new connection list when I connect to my xls file using DAO Access/Excel?
E.g. I'm trying to connect to //.../accounts.xls with a single spreadsheet called "Client List". Once I connect to the file I see two table choices: "'Client List$'" and "'Client List$'_"
Is it significant whether I choose the shorter name, or the one with the underscore after it?
I'm using CR9 Pro. Trying to connect to an Excel 2000 file with single spreadsheet, no freeze panes, no filters, no hidden columns/rows, no print area, no data filters, should be just raw data, perhaps some columns formatted as dates or numbers.
Sorry if this is a repeat question, but didn't find this answered when I searched archives. THANKS!
E.g. I'm trying to connect to //.../accounts.xls with a single spreadsheet called "Client List". Once I connect to the file I see two table choices: "'Client List$'" and "'Client List$'_"
Is it significant whether I choose the shorter name, or the one with the underscore after it?
I'm using CR9 Pro. Trying to connect to an Excel 2000 file with single spreadsheet, no freeze panes, no filters, no hidden columns/rows, no print area, no data filters, should be just raw data, perhaps some columns formatted as dates or numbers.
Sorry if this is a repeat question, but didn't find this answered when I searched archives. THANKS!