[AccessD] Excel import from PHP Excel generated file

Carolyn Johnson cjlabs at att.net
Mon Jun 27 12:34:14 CDT 2011


Thanks.  I'll give it a try.

Carolyn



  ----- Original Message ----- 
  From: Drew Wutka 
  To: Access Developers discussion and problem solving 
  Sent: Monday, June 27, 2011 10:23 AM
  Subject: Re: [AccessD] Excel import from PHP Excel generated file


  http://planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=39892&lngW
  Id=1

  Using ADO for an excel file, allows you to 'read' an excel file like you
  would a regular recordset.  You can set in the flags of the connection
  whether you want to use the first row as field names or not.

  Drew

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn
  Johnson
  Sent: Monday, June 27, 2011 9:53 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Excel import from PHP Excel generated file

  I've only used DAO . . .  I can look back through the discussion and
  check out the ADO stuff.

  I'm assuming there is something wrong with the PHP/Excel generation --
  missing information about the header rows or something that is fixed
  when it is saved in Excel.   I was hoping someone on the list had
  experience with it on that end.


  Carolyn Johnson

    ----- Original Message ----- 
    From: Drew Wutka 
    To: Access Developers discussion and problem solving 
    Sent: Monday, June 27, 2011 9:31 AM
    Subject: Re: [AccessD] Excel import from PHP Excel generated file


    You can use ADO to read excel files..... are you familiar with ADO?

    Drew

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of cjlabs
    Sent: Saturday, June 25, 2011 7:43 AM
    To: Access Developers discussion and problem solving
    Subject: [AccessD] Excel import from PHP Excel generated file

    I'm having a problem importing Excel files generated by PHP-Excel into
    Access.  

    I am using Docmd.TransferSpreadsheet.

    Access is not "seeing" the first row and column of the worksheet, so I
    am getting an error due to a mismatch of field names plus missing the
    first column of data.

    If  I import the excel data without field names, it's still incorrect
    because it does not see the first row/column

    If I try to import the data using the import wizard, Access does not
  see
    the first row and column.


    If I open the PHP-Excel generated  .xls  file in Excel and save it,
    everything works.

    Has anyone had experience with PHP-Excel and could point me in the
  right
    direction with this?  I've tried searching for this problem, but can't
    find a solution.  It seems that something is wrong in the generation
  of
    the Excel file.

    I'd prefer not to use my work-around as a final solution, since it
    presumes the end-user will have Excel on his machine -- not something
  I
    can't count on.



    TIA,
    Carolyn Johnson
    St Louis, MO

    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
    The information contained in this transmission is intended only for
  the person or entity 
    to which it is addressed and may contain II-VI Proprietary and/or
  II-VI Business 
    Sensitive material. If you are not the intended recipient, please
  contact the sender 
    immediately and destroy the material in its entirety, whether
  electronic or hard copy. 
    You are notified that any review, retransmission, copying, disclosure,
  dissemination, 
    or other use of, or taking of any action in reliance upon this
  information by persons 
    or entities other than the intended recipient is prohibited.


    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
  The information contained in this transmission is intended only for the person or entity 
  to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
  Sensitive material. If you are not the intended recipient, please contact the sender 
  immediately and destroy the material in its entirety, whether electronic or hard copy. 
  You are notified that any review, retransmission, copying, disclosure, dissemination, 
  or other use of, or taking of any action in reliance upon this information by persons 
  or entities other than the intended recipient is prohibited.


  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com


More information about the AccessD mailing list