Results 1 to 3 of 3
  1. #1
    baillie is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    1

    Importing Excel and CSV into Access Error

    I am trying to import a large file in either format of Excel or CVS into Access. Would prefer to load the CVS file
    The file is from the National Provider Identifier (NPI) records.
    I have converted the file to Excel, when I tried to Import a CVS I would get Error message: Bad file name or number
    When trying to import as Excel I get the following message: Unexpected error from external database driver.



    CSV file: npidata_20050523-20170507 size 6,158,407 KB
    Exel File: npidata_20050523-20170507 Size 283,866 KB

    If anyone has any idea would greatly appreciate and ones help as looking up 1933 providers to correct another spreadsheet would be easier to build a relational tables instead.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Try manually linking the excel file as an external table. Do not import.
    once linked ,open the table,see if you can view the data.
    if so, run an append query to import.
    If error,see what the problem is.

    if no error, the import steps would be:
    1.overwrite previous excel file (the linked one)
    2. Run append query
    done.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    to the forum.....


    Not really enough info.

    I set up a routine to import 2 CSV files a month - 1 file had around 13,000 lines and the other around 1,200 lines.
    Is this a one time event?


    Do you have a dB?
    Can you provide 5 - 10 lines of the CSV file?

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

Similar Threads

  1. Replies: 5
    Last Post: 10-28-2016, 08:03 AM
  2. Error importing Excel file re search key not found
    By pcbrush in forum Import/Export Data
    Replies: 1
    Last Post: 10-03-2013, 03:19 PM
  3. Replies: 10
    Last Post: 12-28-2012, 02:06 PM
  4. Importing from excel - Unparsable record error
    By jawinterton in forum Import/Export Data
    Replies: 8
    Last Post: 12-08-2011, 02:14 PM
  5. Type error when importing Excel spreadsheet
    By jlmnjem in forum Database Design
    Replies: 2
    Last Post: 08-27-2006, 07:26 PM

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