Search results

  1. N

    uploading .csv file to access

    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...
  2. N

    Opening a file

    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...
  3. N

    Problem with Split Function

    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...
  4. N

    Problem with Split Function

    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...
  5. N

    Unmatched records Urgen help req . Thanks

    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!!
  6. N

    basic Sql Query

    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...
Back
Top Bottom