Steve Goodhall
sgoodhall at comcast.net
Fri Nov 28 10:11:48 CST 2003
One way that I find useful is to treat the Excel workbook as an ODBC data source. This method will also work with CSV text files. This gets around many of the field type problems that can arise with the transfer methods or with linking worksheets as tables. Code for this is on my web site, http://www.goodhall.info/steve/, click on "Useful Software" and download the second item. Regards, Steve Goodhall -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: Friday, November 28, 2003 7:07 AM To: dba-vb Cc: accessd Subject: [AccessD] [dba-VB] TransferSpreadsheet, TransferText To all, I'm writing a VB application which I need to import an Excel spreadsheet and/or a text file into a database.....Is there a VB command similar to this or does someone have some sample code that I could see to get me started... Thanks in advance Paul Hartland _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com