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

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. 
:D
---------
Message sent via  www.excelforums.com 
0
ejohnson1 (2)
11/2/2004 9:45:00 PM
excel 39879 articles. 2 followers. Follow

3 Replies
681 Views

Similar Articles

[PageSpeed] 57

Hi
in Access check 'File - Import External data'

--
Regards
Frank Kabel
Frankfurt, Germany

"RIM-Pro - ExcelForums.com" <ejohnson@sfwmd-dot-gov.no-spam.invalid>
schrieb im Newsbeitrag news:u$5y0USwEHA.3624@TK2MSFTNGP09.phx.gbl...
> 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.
> :D
> ---------
> Message sent via  www.excelforums.com

0
frank.kabel (11126)
11/2/2004 9:50:26 PM
On Tue, 02 Nov 2004 13:45:00 -0800,
ejohnson@sfwmd-dot-gov.no-spam.invalid (RIM-Pro - ExcelForums.com)
wrote:

>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. 
>:D
>---------
>Message sent via  www.excelforums.com 

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 
0
kmas (1)
11/3/2004 2:54:17 PM
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
--------
Message sent via  www.excelforums.com 
0
ejohnson1 (2)
11/3/2004 4:05:03 PM
Reply:

Similar Artilces: