Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KaiserSouza
- Order by date
-
Handling Special Characters
Hi Roy, Thanks for the tip. I actually just imported the table from one to the other and worked everything within access. Well, whadya know? Access figured out the special chars all by itself. Sometimes I try to overcomplicate matters :-)- KaiserSouza
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
INSERT Problem
Hi Mych, Try an INNER JOIN statement in your SQL query I think it goes something like this: INSERT INTO TbleChecklist (ReqNo, projectID ) SELECT TblRequirements.ReqNo, tblRequirements.projectID FROM TblRequirements INNER JOIN tbleChecklist ON tbleChecklist.Reqno = tbleRequirements.Reqno WHERE...- KaiserSouza
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Handling Special Characters
Hi Roy, Thanks for your reply. I've tried the double single-quotes and that worked for strings like "O'Reilly" and such that when I doble the sigle quotes to "O''Reilly", it works like a charm. However, this method of doubling up doesn't work for Ampersands and commas. I was wondering if...- KaiserSouza
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Handling Special Characters
Hi, I'm using a VB app to connect to an Access database via odbc. I'm trying to transfer data from one access database to another using 'company_name' as the index field for both tables. The problem is, company_name may contain special characters i.e. &, literal comma, etc. This is wreaking...- KaiserSouza
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
