Uploading data to our website

  Silkonia 15:31 PM 09 Aug 09

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


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

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

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

See immersive artist and storyteller Chris Milk speak at London VR event

What everyone thinks of the new Steve Jobs movie | 21 Facts about the Steve Jobs film | PLUS:…