From: mikebres on 19 Feb 2010 08:58 I have been experimenting with using ADO to work with Excel data. I had some obstacles with the SQL until I stumbled across a web site that mentioned the table name needed a special format. Instead of using a table name like DATA, instead I had to use the format of [DATA$]. So I was wondering does anybody know of a source (document, web site, etc.) that explains all of the peculiarities of using SQL with Excel? Thanks Mike
|
Pages: 1 Prev: Export to pdf - Office 2007 sp2 issue Next: Worksheet Change Event log for multiple cells |