Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy Data from Excel to Access using Script (HELP)

Status
Not open for further replies.

LongFeiFengWu

Technical User
Nov 9, 2001
98
US
I have never done this and don't even know where to begin. What I need to do is write a script that copies an entire Excel Spreadsheet to an access table without over-writing the existing data. Also the Excel sheets I'll be pulling from lack consistency from cell to cell. The first several rows contain data I don't need and the length of the Excel sheet will change daily.

With all that said...Can anyone out there help me?

"If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo." ~ Bruce Lee
 
This looks more like an in-depth VBA question - post over in those forums for a better response.

:)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top