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.