Search results

I am also getting the same error while I am doing insert. 1) Below insert statement is working fine - here Inserting into access table from linked excel table strSQL = "Insert into tblAccessTag Select * from ExcelTag" CurrentDb.Execute strSQL 2) strSQL = "Insert into ExcelLinkedTbl Select *...

As per msdn - MS access query having User defined functions will not be calling from other applications: social.msdn.microsoft.com/Forums/en-US/accessdev/thread/9d6af5be-be49-4584-b2ff-130b1d4bb5b2

Thanks JHB. It is working fine in Access. But my requirement is, I am executing from excel. The real scenario is: 1) Table tbl2TB_Files contains FName, Fpath fields. The value of the FName is file name and FPath is the full Path of the file. 2) From excel i pass the query to fetch value...

Hello, expecting your expertise in query to solve this Table = TblFolders contains field1 (Only one field) Values - Field1 = "E:\2TB\iCloud\Utilities\Bas\abcdef\" Requirement: Select a,b,c,d,e from TblFolders - expected Result is consider "/" as delimiter and the select result should be...

- Computer programmer for more than 12 years - Worked in vb, sql server 2000, etc - New to Access 2010 - Having interest in MS Office Suit