+ Reply to Thread
Results 1 to 4 of 4

Data Source Import > Errors

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Data Source Import > Errors

    Another basic dumb question from NewYears =D

    I am using a CSV as a source so importing it in as a data source, import works fine but it shows all rows imported but shows 2,500 errors (out of 440k rows). I can click on the text stating 2,500 errors and it brings up a list of what records had errors, but I don't understand what it is consider an "error" or how I can read this. Everything looks normal. How can I specifically see what the errors are?

    Edit://
    I am dumb I now see the ones labeled "error"

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Data Source Import > Errors

    Please attach a sample workbook showing the errors.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,940

    Re: Data Source Import > Errors

    Joseph - I think, from the last line of the OP, that this is resolved.

    NewYears1978 - please mark the thread as solved in the usual way if this is indeed the case. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Data Source Import > Errors

    Oh... thanks Ali!

+ 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. [SOLVED] Data Validation Source=INDIRECT errors
    By katywren in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2020, 05:21 AM
  2. Macro does not wait for data to import from an outside source
    By prent327 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2017, 08:48 AM
  3. Replies: 4
    Last Post: 12-17-2012, 03:01 PM
  4. [SOLVED] Import data from source to target
    By khleisure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2012, 07:34 PM
  5. Replies: 0
    Last Post: 04-06-2009, 11:19 AM
  6. Pivot Table Source Data Errors
    By maacmaac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2008, 09:34 AM
  7. Replies: 0
    Last Post: 03-15-2005, 03:06 PM

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