N
Nakli
Hi,
I would like to upload 50 excel spreadsheets into access that have 12
columns with 8 header lines and different rows in each of the 50
spreadsheets. I am trying to create an upload form in access that
will allow me to import as many spreadsheets as i need to since i need
to do this 4 times a year (for more or less than 50 spreadsheets). is
there a macro or code that will let me cut the header lines out of the
spreadsheets once they are imported in? The tough part is cutting the
ends of the spreadsheet or only uploading to the last row of the
spreadsheet since each spreadsheet has different amount of rows. They
all end at "Elimination totals" so is there a way to import each
spreadsheet that will end at the first blank row after taking out the
first 8 lines of the spreadsheet? (maybe using an if statement)
Also, out of the 12 columns, import only columns A, B, C, D, I, and
L.
The step after importing that i will need to figure out is when
importing column B the values need to be truncated (first letter or
number needs to be cut off when imported in) - example G022 needs to
be 022, 6532 needs to be 532, and 4055 needs to be 055.
Please help me with this dilemma as i do not have import experience
with excel into access.
Thanks for your help
I would like to upload 50 excel spreadsheets into access that have 12
columns with 8 header lines and different rows in each of the 50
spreadsheets. I am trying to create an upload form in access that
will allow me to import as many spreadsheets as i need to since i need
to do this 4 times a year (for more or less than 50 spreadsheets). is
there a macro or code that will let me cut the header lines out of the
spreadsheets once they are imported in? The tough part is cutting the
ends of the spreadsheet or only uploading to the last row of the
spreadsheet since each spreadsheet has different amount of rows. They
all end at "Elimination totals" so is there a way to import each
spreadsheet that will end at the first blank row after taking out the
first 8 lines of the spreadsheet? (maybe using an if statement)
Also, out of the 12 columns, import only columns A, B, C, D, I, and
L.
The step after importing that i will need to figure out is when
importing column B the values need to be truncated (first letter or
number needs to be cut off when imported in) - example G022 needs to
be 022, 6532 needs to be 532, and 4055 needs to be 055.
Please help me with this dilemma as i do not have import experience
with excel into access.
Thanks for your help