Search results

  1. M

    Import csv files and rename them after import into 'imported' and 'failed'

    Hi, I have the following piece of code for importing the .csv files from a selected folder and then renaming them into 'imported & filename' if succesful and 'failed & filename' if import failes for whatever reason (bad formating, etc.). The problem is that the first time it encounters a 'bad'...
  2. M

    Need to import multiple excel files with different number of sheets into access table

    Hi my friends, I need a little help with some code I've come up to in order to import multiple excel files each of them with a different number of worksheets into an access table. The procedure is called from an Access database. The problem I have with the code is that when it encounters a...
  3. M

    SQL Count Distinct Values For Date

    Hello everyone, I have the table 'Transactions' containing all the transactions in an year. The columns of the table are: Transaction_date Type Value Payer_Id Status What I would like to do is a query to group up all the transactions by month, then count the transactions corresponding to each...
Back
Top Bottom