Welcome to WebmasterWorld Guest from 188.8.131.52
I've been told that there is a way I can set one up to use an Excel file as a database, which would be ideal for my uses seeing as how the client sent me an excel file with all their members in it.
Does anyone have a clue as to how I can do this simply? Thanks so much!
For integration into a web site you are likely going to want to export the Excel as a delimited file and upload it to the site, allowing programming to parse it and populate a database. There are API's for direct integration with Excel, but I've never used them, imprting/exporting makes it easier.
Don't know of any freebies or otherwise, but should be fairly trivial for a moderately experienced coder to put together, if they decide to move forward with it.
I've gotta figure out more of the programming end of things I suppose. I typically do simple web design but my boss is pushing me in the direction of programming lately. I have an existing database with tables created already, my big problem is I don't know how to get the info from the Excel file into the database. I'm sure this is a very trivial issue for someone with more experience but being so new to it I don't have the first clue as to how to get rolling in that direction.
I really appreciate your suggestions and advice!