Look at the results from the unfiltered query. Are the column names listed in the rows?
Andy.. I happen to have in the boot of my truck, a book on SQL for Excell etc.Shall I give it to Hunter or you want to swing over and get it? If not, guess I can look thru' and help out.
It does not matter to me or customer if first row does or does not have column/field names.
Where are you defining the connection to the spreadsheet? ie is this code written in VB/Access/Excel ?
Raggy...do you have this already?SELECT members.MembNameFROM (whatever path req)membersThe book says you need brackets round the selection criteria:SELECT members.MembNameFROM (whatever path req)membersWHERE [members.MembName ='bert']Try that..if it doesn't work will have another bash.
Become a fan of Visordown
Follow us on twitter
Other Immediate Media Sites
Our eCommerce Platform
© Immediate Media Company Ltd 2012. This website is owned and published by Immediate Media Company Limited. www.immediatemedia.co.uk