November 22nd, 2005, 12:51 PM
|
|
Contributing User
|
|
Join Date: Jul 2005
Posts: 76
Time spent in forums: 19 h 59 m 6 sec
Reputation Power: 4
|
|
|
connect Excel to Access with Macro (VBA)
I am trying to connect Excel to Access and I learned that I would have to write a Macro script (VBA code) that will allow user to upload their Excel data to Access. I am new to Macro so can someone guide me on how I should approach this situation.
In Excel, there are 7 columns however in Access there are 5 columns. Some columns in Excel are combined in Access into 1. So, I need a way to combine some columns before uploading to Access. Also, the user would have the copy of it for their reference.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
