+ Reply to Thread
Results 1 to 2 of 2

CSV Query

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    66

    CSV Query

    Hi there,

    I am having a great big problem with a CSV file!

    Currently we have a master database of supplier names with relevant bank codes in excel format.

    I then input the amounts next to it and save as a CSV format.

    When I go into online banking to upload the file it does not work.

    However from the master database of supplier names (lets say im making one payment only) ;- if I manually type the account details and names & input the name (into the exact same file), convert into CSV format the file will upload. But if I use the details already there and only type the amounts it wont upload.

    It makes no sense to me.

    any help?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: CSV Query

    If you look at the two files in, say, Notepad can you see any differences? Is one comma delimited and the other tab delimited? Are there any double quotes around any of the entries? If you can look at the files in something like a Hex Editor, what character or characters is/are at the end of each line?

    If you create more than one entry in the Master file and convert them to .csv, does the file still work?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-01-2013, 04:21 PM
  2. [SOLVED] Loop through list, perform web query and save each query on its own page
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 07:50 AM
  3. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  4. Web Query - Change a word in query to form a new query
    By scottymelloty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 04:13 AM
  5. Query Data in hidden rows/columns with Query Box
    By VincetOmnia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 10:53 PM

Tags for this Thread

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