-
Solved: SQL error
I am having trouble ( as usual
) with the following
I am using excel to extract records from an access database and have got stuck with the following
[vba]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;"[/vba]
I am getting a sytax error
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules