Search results

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

Hi, I have many fields, so i need someway to get the names of the fields. in sql one could use the table name object and get the colids from there, i am not sure if there is an equivalent phrase in access. Thanks A

update query I can use the update query but I want to use a generic query which gets the fieldnames and updates each of the fields. initially all the data is imported as text and hence i get around the problem of setting numeric values to null.

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

Thanks, I guess that was what I was doing. I was looking for something equivalent to stored procedures in SQL to be executed in access, and hence tried to write the visual basic procedures. What would be an equivalent of a stored procedure in sql to something in access. i want to look through...

yes that is what is defined in the control panel->administrative tools->data sources, and it uses the microsoft access driver

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