Hi Lonnie, If you haven't already done so, you can incorporate a DTS package into your VBA code. Save the DTS script as a VB file, then copy and paste it into your Access front end, and run it. This method utlizes the speed of the DTS (you will need to add a reference to DTS in your Access app). I applied the above method to import a big CSV file into a SQL Server table. Angelo
----- Original Message ----- From: Lonnie Johnson [mailto:[EMAIL PROTECTED] Sent: 8/23/2005 7:43:01 AM To: [email protected] Subject: [AccessDevelopers] VBA to ActiveX I have lots of VBA code in an Access datatabase that runs each night to update various tables and values based on certain conditions. Some of it is complicated such as calculating distance based on longitude and latitude and it is why I use VBA. However, I would like to move this processing over to our SQL Server. Would it be easy to convert some of the functions to DTS ActiveX packages? Is this even the way to go? I am looking to increase the performance and figured I could do so by moving it to the SQL Server side. May God bless you beyond your imagination! Lonnie Johnson ProDev , Professional Development of MS Access Databases Visit me at == > [http://www.prodev.us/]http://www.prodev.us [http://www.galaxymall.com/software/PRODEV] -------------------------------------------------------------------------------- [http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs]Start your day with Yahoo! - make it your home page Please zip all files prior to uploading to Files section. SPONSORED LINKS [http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig=TjCMMZaJBtroyAQ8dznVsQ]Microsoft access database [http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+developer&w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig=oqhFqsmlUZ5Zh6pQgnvTDQ]Microsoft access developer [http://groups.yahoo.com/gads?t=ms&k=Microsoft+access&w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig=MMKzpewSlzpK714XaCARAQ]Microsoft access [http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+design&w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig=ecBsMdKeZw8i4_1kkC6epA]Microsoft access database design [http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+training&w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&c=5&s=163&.sig=FHk4Yggbv_zB-TsXvHyeig]Microsoft access database training -------------------------------------------------------------------------------- YAHOO! GROUPS LINKS ยท Visit your group " [http://groups.yahoo.com/group/AccessDevelopers] AccessDevelopers " on the web. To unsubscribe from this group, send an email to: [mailto:[EMAIL PROTECTED]@yahoogroups.com Your use of Yahoo! Groups is subject to the [http://docs.yahoo.com/info/terms/]Yahoo! Terms of Service . --------------------------------------------------------------------------------
