Any tips? Thanks guys. :)

Sorry, been really busy and haven't checked this thread in a little while, thanks for your responses though. I'm using the VB built into Access. I'm not using any sort of import function as of right now...this is the code i'm using right now to import an excel file into the access database.

[CODE=vb]Sub test()
Dim con As New ADODB.Connectio n

con.Open _
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\sampl eimport2.mdb;Je t...

Hi all, I have a vb question that i'm hoping I can get some help with.

I have a directory of excel files (probably about 1000) of them. They are quote sheets for the company I work for, and they are all the exact same format. I need to create some code in vb using microsoft access that will scan through this directory of excel files, and pull certain cells of information from each of them, and store this information into an access...