Search results

Hi All, I have a table that contians more than 70,000 rows, where I want to export the table as two different excel files. 1. One excel file data from 1 to 65000 rows 2. Second excel file from 65000 to end of table. Can any one help in this regard. Regards, HARI

Hi All, I need to search case sensitive text in a filed I need to find out the data with “Ltd” only from below data ABL BIO-TECHNOLOGIES LTD ABL BIO-TECHNOLOGIES LtD ABL BIO-TECHNOLOGIES ltd ABL BIO-TECHNOLOGIES lTD ABL BIO-TECHNOLOGIES Ltd I am useing below query but it giving all the...

Good Morning All, I have small requirement with Replace function, as per my understanding Replace function is used to replace a text in a filed. My requirement is if one filed contians more than 10 words to replace at once, how to repeat the sam function for that filed to give output in...

Hi All, I am useing below code to concatenate the different fileds, omit if columns contians % as well as dates. A small bug found in the code, where the total filed [Expr10] of data unable to concatenate in filed as "Name" (query: 1_1) attached screenshot and sample dbf. can you help in...

Good Morning, I am useing below code to download the comma delimited text files to access table. Function Load_Attendance_Data() Dim NextFile, ImportFile, FileCriteria, ctr As Variant Dim DB_Path As Variant ' get the DB path DB_Path = "C:\temp\" FileCriteria = "C:\temp\" & "*.txt" ' create...

HI All, Can any one help to my query I have a table with coloumn called rate, i want to update that filed with percentage as per below criteria. 1. If the rate contains 4th decimal that's rounded to 3rd decimal (Ex. 1.2564 as 1.256 or 3.5689 to 3.569%) 2. if the rate does not contian second...