Search results

Hi all, I am trying to import variable data from excel into a database and in particular a table. However the data in Excel is in column and the table in rows. I have the following code borrowed from here: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst But I am unsure how to...

I have searched through the forums regarding this and have tried several of the suggested solutions but I have not had any luck, so I am starting my own thread with the hope that someone will be able to help me. I have an Access 2007 database which data is saved into and using VBA data is...

Hi all, I am new to access 2007 and have brought a database through from 2003. I am having trouble getting some code to work which is run from a button on a form. Is there a major change in the code for 2007 to make the following stop working: Private Sub ExcelExport() 'Declare a variable...

I am having trouble finding the VBA code behind a button placed on a form in Access 2007. I have placed a run query button on a form using the wizard. Using alt F11 I bring up VBA to view the code but I can’t find anything in VBA. I want to modify the code so I can get several commands on one...

Hello, I am in the process of creating an inspection database for a manufacturing company I work for. The idea being to store a large amount of data currently stored in separate excel spreadsheets in a single access database, to enable easier queries of the data. I am currently struggling...