Search results

There's only 1 Sheet per excel file that needs to be touched. So basically it's going to be a macro that loops through a directory of excel files one by one and plucks the same cells of information out of each of them, and puts them into a table. And yes I only need certain cells of information...

Believe me if I knew how to do it I would have already, I believe that's why i'm coming to this board for help... :)

So nobody on this board knows how to do this? It can't be THAT difficult to do.

Oh and this is the code i'm using to read the excel files right now: Dim con As New ADODB.Connection con.Open _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\sampleimport.mdb;Jet OLEDB:Engine Type=4" Dim strSQL As String strSQL = "SELECT * INTO Table2 FROM [Sheet1$] IN ""C:\test.xls""...

Alright, so i've got it to the point where i'm reading excel data into access, however there are 2 problems. 1)It's only reading one file (it needs to loop through a directory of excel files and read them all) 2)It's importing the WHOLE excel file. I need to be able to select the individual...

yes, all the quote sheets are the exact same format. i'm just not sure how to make access communicate with excel like that so you can extract data from specific cells within the excel document. For example, there is a description area on the quote sheet that tells what kind of job it is, flyers...

So you're recommending all this be accompished in access, no need to touch any other program such as visual studio? And yes, i'm definetly no expert in programming access, but I do have general programming knowledge. anyways, thanks for the list idea, here's what I basically need to...

i'm beginning to think now I should just use visual studio and basically create a form identical to the one that I posted a picture of, and use visual studio to connect to access and display the data in there. the VB that's included in access is garbage and it will probably be a lot easier in...

Please explain? I don't need to use VB? Please explain the process you would go about doing this.

I'm not sure if the attachment worked or not so here's a direct link the a picture of what i'm talking about...thanks guys. http://img.photobucket.com/albums/v136/paul88/quotesheet.jpg

Hey guys, new here and I need a little help with a project my boss wants me to complete. Basically right now, he has a huge directory of quote sheets that he fills out whenever he wants to generate a quote for a customer (they are excel files, i've attached a picture of one). He wants me to...