Search results

Sure. Here you go - the VAR is variance between last year (far left) and this year (middle) - actually, didn't know how to insert it here, so attached it.

Thanks, Robert88. I think you get what I'm trying to do....but still not sure how to move the fld* values from excel into the fld* fields in access.

Thanks, everyone. Stephen - you're correct - the 'fieldname1, 2, 3...' are to be records with each containing the 'fn1-net, fn1-gross, fn1-billed' fields. And, you're also right - the variance field will be calculated based on comparisons from the previous year's net/gross/billed info, but I...

Thanks, Rickster57. I've searched through this forum and everywhere else I can find and I cannot find an example of the transferspreadsheet command needed to do what I need. Based on my example above, I think, basically, I need it to create a table with field names such as "fieldname1-net"...

I am trying to import an excel spreadsheet into access. The problem is that spreadsheet is laid out as follows: ................net.........billed.......gross.....variance fieldname1...1value1...1value2...1value3...1value4 fieldname2...2value1...2value2...2value3...2value4...

Import complex report Excel - Access I am trying to import and Excel spreadsheet into Access. The difference is that I only need about a third of the spreadsheet. Also, the headers are on the left side of the page with the information going from left to right and some columns are null, and...