Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lollytyg

    For those of you who use VBA to code to databases

    Just a snippit, dont wanna use it? np. Yes I use queries, and occasionally the SSMS to talk to SQL, but that's just me. The object here was to write to Access or SQL using ADO and VBA from an emailed, Zipped, CSV. In my case the VBA is doing a lot of validation on a per line basis, b4 it's...
  2. lollytyg

    For those of you who use VBA to code to databases

    Sry Dhookum, Thank you for the forum tips... Hope you guys can use it... lolly
  3. lollytyg

    For those of you who use VBA to code to databases

    Skip, thanx for the posting tips... Sql or Access, open a table, select one line, external data, export to excel, structure and data, selected only, OK... pops a blank excel ss, and populates with the headers, and how many ever lines you have selected. This example assumes you will be coding...
  4. lollytyg

    For those of you who use VBA to code to databases

    Here's a tip... Some of the databases out there are not code monkey friendly and I for one hate typing all those field names over and over. Use VBA to write the code for you... Open SQL or Access and EXPORT to excel, select just one line, make sure you tell it only selected data. Pasted to...

Part and Inventory Search

Back
Top