12-03-2004, 06:03 PM
I have a bunch of spreadsheets that are posted on our company website that I save to my hard drive as csv files and chop up with a script that puts them in an access database. I wonder though is there a resource I could look into that would allow me to traverse the spreadsheet in a similar fashion as I do with a csv directly from the website. I know I can just import the spreadsheet put that doesn't work so well, data types and all.
I'm unsure why opening the files directly in access is not sufficient - data-type problems can generally be cleaned up easily enough. If the data is consistently of the same type, you simply import it into a predefined table structure. Without more detail, all I can do is guess.
The two options I can think of are a commercial PHP product that parses Excel files: PHP Excel Parser Pro (http://www.zakkis.ca/products/) or to write an Excel VBA app that parses the sheets. I think in either case, it wouldn't take a lot of work to get it to write directly to an access database.
12-04-2004, 06:24 PM
I'm still not entirely sure I understand your problem.