[b]Can I download Excel data to a MS Access database?[/b]

[RIM-Pro - ExcelForums.com]

I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
database).

Is this possible or even feasible? Any and all help is appreciated.

Thanks.

 

[Frank Kabel]

Hi
in Access check 'File - Import External data'

 

[GL Fowler]

I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
database).

Is this possible or even feasible? Any and all help is appreciated.

Thanks.

Goto www.exceltip.com and search for Export Excel to Access. You
should find code to use ADO or DAO to solve your quest.


"The best proof of intelligent life in space is that it hasn't come here."
- Sir Arthur C. Clarke

 

[RIM-Pro - ExcelForums.com]

Good morning all and thanks for the replies..

I realize now that I didn't state my problem correctly, as I a
familiar with importing Excel data into an Access database. What
really want to do is automatically import selected fields of an Exce
form into their coordinating fields of an Access database that I'v
already built. In other words, for example I'd like to import th
data from the "Name" field of the Excel form into the "Name" field o
the Access database

Also, my Excel form is a tiypical form with data fields spead out ove
the form, so because the top row does not contain column headings
straight import or copy would not work

Thanks
Ear