MastercafeCTV
mastercafe at ctv.es
Tue Jan 6 12:19:06 CST 2004
We had developed a similar function that you select the Excel.Column Data and assign to File.Field Data. The process was simple. Make a Form with this fields: Excel Origin / Excel Column / Access Database / Access Recordser / Access Field (dbText, 80) is better because you can convert this to Csng/Clng and use this. Design the main import form and then execute a Sub that open Excel and check main data to transfer to end Database. I will check our code to look for this and send you a copy of this. Juan Menendez =========================================== MASTERCAFE SL - NIF B-82.617.614 www.mastercafe.com Deleg. Asturias Tel 985.88.49.44 / 627.531.764 Fax 627.500.205 info at mastercafe.com juan at mastercafe.com Deleg. Madrid Tel 627.474.285 cecilia at mastercafe.com =========================================== -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: martes, 06 de enero de 2004 15:50 To: Access Developers discussion and problem solving Subject: [AccessD] Excel to Access by clicking cells. Hi guys Just brainstorming with myself to improve some stuff... We receive on a daily basis (7x7) a lot of excel files with data in it from several sources. We can not standarise those files for several reasons so we print these files en type the data manualy in Access. I was wondering if anyone ever has written a function so you could click the cells with the data and then right-click something and the data is passed to a recordset in Access depending on your multiselect order in Excel. Importing is not an option because these files change to much and are often to complex (more data in the file then we need). The data are boxoffice figures from cinema theatres. So the data we need as a result looks like this. Date1 MovieA Tickets Amount Date1 MovieB Tickets Amount Date1 MovieC Tickets Amount Date2 MovieA Tickets Amount Date2 MovieC Tickets Amount Date2 MovieD Tickets Amount The excel sheets can vary, it can be horizontal, vertical, double vertical double horizontal... So I believe a multi select would be a solution. I think it will be faster than printing and manual typing. I just want some code that put me on the road with this multiselecting thing and passing to Access. Erwin Erwin Craps Zaakvoerder www.ithelps.be/jonathan This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com