...

View Full Version : Getting Excel Data To Access



Basscyst
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.

Thanks,
Basscyst

Kiwi
12-04-2004, 12:28 PM
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.

Basscyst
12-04-2004, 06:24 PM
I don't import because I am not the one importing, else I would just do as such. I have a javascript program that chops it up when saved as csv. This way any laymen can update the data. They do however have to navigate to the site replace all instances of commas with | and save the page as csv. Then they just run it through a input type=file and press go. If I could get it to read directly off the webpage then I could cut the administrator out all together. I don't have a web server, this is a clientside application. So I don't think the php thing would work.

Basscyst

Kiwi
12-05-2004, 05:34 AM
I'm still not entirely sure I understand your problem.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum