lifeson
01-31-2008, 05:35 AM
I am having trouble ( as usual :bug: ) with the following
I am using excel to extract records from an access database and have got stuck with the following
Src = "SELECT TblAddress.AddressType, _
TblAddress.LeadNumber, _
TblAddress.Title, _
TblAddress.LastName, _
TblAddress.AddressLine1, _
TblAddress.PostCodeIn, _
TblAddress.PostCodeOut FROM TblAddress _
WHERE (((TblAddress.AddressType) = "I")) _
WITH OWNERACCESS OPTION;"
I am getting a sytax error :doh:
I don't think I've got the line wrapping right and when I put it all on one line, (((TblAddress.AddressType) = "I")) causes a problem aswell
Any help greatly appreciated.
I am using excel to extract records from an access database and have got stuck with the following
Src = "SELECT TblAddress.AddressType, _
TblAddress.LeadNumber, _
TblAddress.Title, _
TblAddress.LastName, _
TblAddress.AddressLine1, _
TblAddress.PostCodeIn, _
TblAddress.PostCodeOut FROM TblAddress _
WHERE (((TblAddress.AddressType) = "I")) _
WITH OWNERACCESS OPTION;"
I am getting a sytax error :doh:
I don't think I've got the line wrapping right and when I put it all on one line, (((TblAddress.AddressType) = "I")) causes a problem aswell
Any help greatly appreciated.