Results 1 to 2 of 2
2002-01-08, 23:37 #1
- Join Date
- Jan 2001
- Baltimore, MD, Maryland, USA
- Thanked 0 Times in 0 Posts
USing DAO to query XLS Table (Office 97 Win98)
Hi Fellow Loungers and Happy New Year to you all:
I have a simple question today. How do I set up some columns and rows in an XL worksheet to be a data table so I can connect to it using DAO? When I use my ODBC connection from another XL file and specify the target file, I get the message that there is no data table in that file.
Thanks <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
2002-01-09, 17:00 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: USing DAO to query XLS Table (Office 97 Win98)
Happy New year to you too.
If you are getting info from Excel to Excel why not use the simpler methods than DAO?
But I guess if you would give the range a name say Database, then Excel will know what you want. I did run through something similar and all I had to do is give it a name.
Now as to the header row, I can't remember if it should be included or not, try both cases.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>