|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
 |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
June 10th, 2004, 11:00 AM
|
|||
|
|||
|
Import multiple excel files
Can someone tell me how to import multiple excel files into an access database. I have over 100 fiels that I need to import. Thanks.
|
|
#2
June 15th, 2004, 07:20 AM
|
|||
|
|||
|
Import multiple excel files
Can you explain further. If you are importing several Excel files that have the exact same fields, I would say that you need to have headers with the exact same wording as the Access fields of the table to which you're importing. Look up the transferfromspreadsheet function in Access vba, this will explain how to automate the import and make it seamless.
Creo 
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Import multiple excel files |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
