newbee need's advice

T

terry

I will be creating a database , nothing special , the problem is I will need
to import some excel spreadsheet data (about 150 sheetswith 200 to 400 lines
) all of the sheets have the same format, with data begining on line 5 , is
their a way to automate this process, so I don't have to manualy import each
sheet.

Thank you in advance for your guidence
 
K

Keith

terry said:
I will need
to import some excel spreadsheet data (about 150 sheetswith 200 to 400
lines
) all of the sheets have the same format, with data begining on line 5 ,
is
their a way to automate this process, so I don't have to manualy import
each
sheet.
Yes but it would involve writing a VBA routine, there's nothing out of the
box that will do it for you.

Keith.
www.keithwilby.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top