Using ODBC to access XLS files.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

I'm using ODBC to access the content of XLS files.

I see that the "table" names are in mainly in the form ...

worksheet$
'work sheet$'

This is fine - these match existing worksheets - Append $ and wrap with
single quotes if necessary.

But I also have those that are like ...

worksheet - no $
worksheet$_ - trailing underscore

I'm not able to use some of these.

What are they?

What other formats exist?

Regards,

Richard Quadling.
 
Back
Top