Skip to main content
A
acidrain9
Known Participant
November 6, 2006
Question

Update Database from xls

  • November 6, 2006
  • 1 reply
  • 212 views
i have an access database on my site that needs to be updated from an excel xls document. is there a way i can upload the xls file and have it update my database?
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
November 6, 2006
Yes, you can but you need to create named ranges on the spreadsheet and hand
code the update bahviour. How easy this is to do depends upon the langauage
that you are using.


--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:einke0$ai2$1@forums.macromedia.com...
>i have an access database on my site that needs to be updated from an excel
>xls document. is there a way i can upload the xls file and have it update
>my database?


Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices