+ Reply to Thread
Results 1 to 3 of 3

Foxpro csv to Excel double quote error

  1. #1
    Registered User
    Join Date
    10-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Foxpro csv to Excel double quote error

    I am trying to import a CSV file from Foxpro into Excel 2010. When a description field ends in " Excel doesn't import correctly. The double quote is removed from the end of the description and placed at the beginning of the next field.

    I have tried many different ways but all with the same results.

    HELP!

    LPD

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Foxpro csv to Excel double quote error

    Rather than double-click the file to open it (or using Excel's File | Open), you should click on Data then in the Get External Data group you can click on From Text. Then navigate to your file and double-click the icon - that takes you into the Text Import Wizard, which has 3 dialogue boxes. On the first of these you should click Delimited then Next; On the second panel you should click against your delimiter (comma) then click Next; on the final panel you can select each field in turn and tell Excel how you want those fields to be treated. So click in the column(s) with the problem, then click Text. When you are done, just click Finish. Excel will ask where you want the file to be imported to - just accept the default of A1.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-27-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Foxpro csv to Excel double quote error

    I found out that Excel will import a DBF file directly and that seems to work. Now I need to save the Excel file in a format that I can read into Foxpro. There is no export wizard and all the choices that I have tried stumble on the double quote.

+ 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. remove double quote marks when pasting into notepad
    By frantan in forum Excel General
    Replies: 6
    Last Post: 02-06-2014, 03:49 PM
  2. Removing double quote on null column
    By lilvi3tboix1 in forum Excel General
    Replies: 5
    Last Post: 01-11-2011, 09:32 AM
  3. double quote
    By ilkamalo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2010, 07:12 AM
  4. Double Quote Leading to Apostrophe Problem
    By ToferKing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2006, 11:45 AM
  5. Exporting single or double quote delimited files
    By Greegan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2005, 01:08 AM

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