Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts

    Getting Excel Data To Access

    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
    Helping to build a bigger box. - Adam Matthews

  • #2
    Regular Coder
    Join Date
    Oct 2002
    Posts
    380
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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 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.

  • #3
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts
    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
    Helping to build a bigger box. - Adam Matthews

  • #4
    Regular Coder
    Join Date
    Oct 2002
    Posts
    380
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm still not entirely sure I understand your problem.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •