Drew Wutka
DWUTKA at Marlow.com
Mon Jun 27 10:23:07 CDT 2011
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.