Uploading data to our website

  Silkonia 15:31 PM 09 Aug 09
Locked

Hello - we are creating a list-based website and are wondering what the best software is to use to input the basic data before we upload it through Dreamweaver onto the site. Excel? Access? Any help would be much appreciated - thank you

  Forum Editor 19:24 PM 12 Aug 09

include a MySQL database? It probably does, and you can populate it with data fairly easily by using say, and Excel csv file, and the tools provided in MySQL.

You can certainly use Access as well, and use its data connection facility to get the data into MySQL.

A lot depends on your level of expertise, and on what form the data will take.

  Silkonia 19:44 PM 12 Aug 09

Expertise - pretty basic! We are having a look at it now - the listings will be linked into 3rd party websites... does that influence the way we go?

  OTT_Buzzard 17:07 PM 13 Aug 09

The way you put data ino the database doesn't affect the way that it exits...for example to a 3rd party website. Just be careful about who can access the database without your permission.

Depending on the interface you have with your mySQL database-to-be, you could well be able to manually enter the list(s). If not, it's possible to create a link between an access database / excel spreadsheet and the mySQL database. You'll need to learn a few tips and tricks, but I suspect that's inevitable if you haven't done anything similar before.

  Silkonia 08:13 AM 14 Aug 09

Any, and all, help is much appreciated!
I am happy using excel, so this is probably the preferred route. Just need to work through the actual process. Thanks

Advertisement

This thread is now locked and can not be replied to.

Sony Xperia Z5 review: Hands-on with the phone which the Z3+ should have been

1995-2015: How technology has changed the world in 20 years

How to choose a photographer

iPhone 6S preview: What to expect from Apple's next iPhone