+ Reply to Thread
Results 1 to 2 of 2

Getting data from external csv source

  1. #1
    Registered User
    Join Date
    07-11-2008
    Location
    Oslo, Norway
    Posts
    15

    Getting data from external csv source

    Hi,

    I used to get data from external excel, access files and today tried to put together query to get data from CSV file. While using same source file, I have creted several queries to get data out based on criteria. For some strange reason, same structure queries that did run with excel or access as data source, does not want to work the same way with CSV files.

    Here is example of non working query SQL:
    SELECT Vendors.Vendor, Vendors.Name, Vendors.`Name 2`
    FROM `Q:\Finance\Rapporter\PS\AP\Raw`\Vendors.csv Vendors
    WHERE (Vendors.Name Like '%' & ? & '%')

    If I enter "London" as a criteria input, it will not work. However, if I enter "ondon" it will find me all values records whre name contains London... Seems like I need to skip first symbol when entering criteria. This is, of course, not something I would like to do.

    Any ideas, what mistake have I done in SQL? Strange thing is that it works perfect while in Microsoft Query application. Then I do enter "London" and it will list me all records. However, once I select "Return data to Excel" it sends me empty list... and then I need to retype criteria to "ondon" to get my list in Excel

  2. #2
    Registered User
    Join Date
    07-11-2008
    Location
    Oslo, Norway
    Posts
    15
    Sorted out... it was lower and upper case problem. Seems like Microsoft Query is case sensitive...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1