StaRKeY
starkey at wanadoo.nl
Fri Nov 28 10:48:27 CST 2003
Hi Paul, sorry no code but in VB you should use the Objectmodel of Excel. Create a new instance and set the worksheet to the file. Then using the objectmodel you're able to read out the specific values and append them to a table using a recordset/SQL. I assume the sheet will always look the same or is used only once. Regards, Eric STarkenburg -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: vrijdag 28 november 2003 13:07 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 --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 28-11-2003 Tested on: 28-11-2003 17:48:26 avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com