Search results

Thanks for the reply.. I did try this before and it works, but in some instances it doesnt upload all the records in the file and creates a errortable. Neer

Hi all, I am trying to upload this .csv file in the access table. The file has 6 columns. Id, date, bank, description, debit, credit, Dem, SMP Last two columns may or may not have value for certain rows. Tried using Split function and then using DoCmd. But the problem is the description...

Hello all, I am trying to open a file from my application. My table has member record and a location of the relevant member details file in a text field. Now I want that the user clicks on the command button and is able to view the file. The problem is that the file can be anything thing...

Problem with split function Thanks Lagbolt, The code worked .. Thanks a lot..!! Neer

split Function Thanks Logbolt, I think this should work.., will try the it out with my file and get back to you..!! Thanks again..!! Neerja

I am trying to upload some data from a .csv file to access table. For this I am using Input Line and then using the split function with “,” as delimiter to put the values in an array and then upload it to access. The file that I want to upload, has a number column as amount. It has no $ sign...

I am trying to upload some data from a .csv file to access table. For this I am using Input Line and then using the split function with “,” as delimiter to put the values in an array and then upload it to access. The file that I want to upload, has a number column as amount. It has no $ sign...

Hello all, I have 2 tables. I wish to fetch all the records which are not common in two tables. I do not have Exp with the Unmatched query wizard. I want to sleect the records based on more than one criteria and wizards allows to select on only one field. Any suggestions please. Thanks!!

Union Hi again, I created two queries to select the desred records from each table. Now the problem I am facing is that I have s that from the output of these 2 queries, I have to pick records that do not common values in both the tables. Any suggestions please......!! Thanks in advance Nee

Help please.. Thanks for the reply Rak, My two tables are not exactly similar. These columns are part of the two different tables on which I have to query on. And because these are two different tables when I join the tables the rows are getting duplicated. Any suggestions Thanks!! Nee

Hello all This is a pretty basic query I guess but I am having trouble solving this.. Can anyone help plsssssssss. I have two tables Table1 Code Serial_No Amount1 Amount2 1 ABC 100 200 1 ABC 720 220 4 ABC 150 112 9 PQR...