Member Avatar for Sidicus

Hello Everyone,

I am trying to find a good way to get information from a website into a access 2007 database.

Im thinking I should have the website write a text or xml file with the data on it and then have some program (or access itself if it can) write it to the database. Not sure if this is the right direction. At the moment im not worried about security.

Any suggestions?

Thanks

Sidicus

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by leo002000
Member Avatar for leo002000

Have the website dump some text data (tab or csv) to a share where you can link the access database (table) to the text file..

1 = from access 2007 go to External data tab > text > navigate to the file

2 = Choose the 3rd option "link to the data source by creating a linked table"

As the text file is updated so is the linked table... :)

It really is that simple

Cheers

Leo :)

Edited by leo002000 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.