Results 1 to 2 of 2

Thread: [Access 2003] Multiple SQL Queries

  1. Nov 13th, 2007, 10:44 AM #1
    agmorgan
    agmorgan is offline

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    [Access 2003] Multiple SQL Queries

    Is it possible to run multiple queries in SQL (in access) separated by a semi-colon?
    I have a large csv file without reference numbers and I am trying to match up the rows with another (larger) csv file that does have references.
    I figured the easiest way to get the references would be to import the csv into access and run some SQL that matched up certain fields.
    I can also create the queries in Excel by writing it once then using autofill down.

    Unfortunately I can't seem to run them all at once.
    Can you import queries from a text file?
    Help me with my PKR Hand History Tool
    AutoUpdater - ActiveX Control Format numbers to Significant Figures
    Delete Recent Projects from VB6 IDE Emulate Windows 95 Powertoys Regex in Excel
    Reply With Quote Reply With Quote
  2. Nov 13th, 2007, 02:34 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [Access 2003] Multiple SQL Queries

    I have queries that I import from a text file. It is just a matter of reading the text file, storing what is in it in a string, and then executing that string (I'm using VB6 - should be able to do the same in VBA though)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width