Search results

  1. A

    importing multiple excel files into a single access table

    Hi, I have multiple excel files in the same format but data for different dates. i would like to import those into a single access file with an additional field of date. how can i do this programmatically, since the number of files is large i.e. more than 100. Best Regards, Arjun Bhandari
  2. A

    stored procedures

    Hi, I am switching from sql server to msaccess and cannot find an equivalent of a stored procedure in access. The task I want to do is the following. 1. I have a table with many field.s 2. I want to loop through all the fields and replace records which have a value of 0 with NULL. How could...
  3. A

    access database error

    Hi, I am new to the use of access. I have defined the database in the dsn and named that 'abexp', now when i go to access open the database and then create a module and try to establish a connection to the abexp, it gives me an error - database has been placed in a state by an unknown user that...
Back
Top Bottom