Hi
I am a new bie with Access07. I work in an Oil and Gas services company and have no back groud in programming or database design.
I wanted to design the VBA code for importing an Excel Sheet into Access.
I have defined the table (with required columns and properties).
Basically the VBA code should do the following.
1) Open a pop up(when clicked button on form) which I can use to select the file I want to import(just like when we click the open button on Word and user can navigate where his/her file is stored onto disk)
2) Then the rest importing steps should be automated – that is regarding selecting the “Table” where I want to import the file, selecting the excel work sheet to be used for importing and using first column for table header.
Can someone please help me write this code as I am desperately running against time to submit this project.
Will be extremely greatful for the help/ suggestions. Or write me a example code and I have no knowledge to do so.
Thanks and Regards,
Prashant Kumar.

I'm not aware of access being able to have a selectable process for importing a file of your choice. I.e File, import, etc. So, maybe someone with more experience can do a better job.

When I import Excel files, I create a macro to import the Excel file. I place this code behind a pushbutton on a form. The drawback is that the file you import has to have the same name. So, some manual intervention is involed for each file you want to import. With the macro, you can code it to import into a specific table and then move to another table for processing then delete the contents of the table that it was originally imported into. Otherwise, I think you would have to develop an appliation in .net or someting along that lines to do what you want.

All,

If I'm wrong, I'm willing to learn.

John