Results 1 to 2 of 2
  1. #1
    johnny1g is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Sep 2009
    Posts
    2

    Importing from CSV file

    When I import the file it is imported into a table then manipulated and then put in to a final table. There are 10 queries running from macro .
    My problem every time it is to perform a query I get a pop up asking if it is ok, this is very annoying. How can I eliminate this verification

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,943
    Use SetWarnings method before and after running the queries. Review http://office.microsoft.com/en-us/ac...001226301.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-05-2014, 04:25 AM
  2. Importing file directly from a Sharepoint file (not list)
    By jstoler in forum Import/Export Data
    Replies: 1
    Last Post: 06-28-2013, 01:44 PM
  3. Importing .csv file
    By Emma35 in forum Import/Export Data
    Replies: 13
    Last Post: 04-03-2013, 08:40 AM
  4. Importing CSV file using VBA
    By falconfox in forum Import/Export Data
    Replies: 1
    Last Post: 12-05-2012, 10:32 PM
  5. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums