Hi all,
I am developing an Access database that will use, as inputs, many
Excel spreadsheets. Each spreadsheet is a list of graduates of this
or that school course. One spreadsheet per course.
Each spreadsheet is formatted exactly the same, just different
graduate and course-specific data on each.
I am trying to use VBA to automate (as much as possible) the
importation of all these Excel spreadsheets into an Access table for
furher processing.
There is one major problem: each spreadsheet has a header area across
the first few rows with data like today's date, name of the course
and the fiscal year. Some of this info, I need to import along with
the graduate data (like the fiscal year and name of the course) and
some of this header data I don't need. Of course, below this header
area are all the columns of graduate data that I need to import.
Does anyone in this group have any experience in
1. Automation of importing spreadsheet data into Access using VBA
(especially how to exclude the first few rows of data from
importation)
2. Using VBA to "crawl" a spreadsheet and just pick out certain
pieces of data (such as the fiscal year and course name mentioned
above)?
I'm trying to figure out how to use VBA to do both these tasks with
the click of a button on an Access form...
Thanks ahead of time for any input y'all may have!
Rick
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
