Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > Premier Manufacturing and Wholesale Edition Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 08-18-2017, 09:48 AM
tjharring tjharring is offline
Registered User
 
Join Date: Sep 2011
Posts: 5
Importing Excel price list issue

I am using QB Ver. 15. I have am Excel worksheet with updated product information. When I receive the info from my vendor I have to modify the worksheet and add several columns to it. Once I complete the import the first time QB will have update any of the item numbers that already exist in the system. I will then tell me how many errors I had and ask if I want to save them to a report, which I do. I always save them so I can review them.

Generally the numbers it saves to the report are new numbers that were not already in the system. I add the necessary columns to the worksheet and save it. I have a different mapping configuration for the new item numbers that I use. I have never had this problem in the past. When I tried to import the new numbers into the system I receive an error just trying to select the file to use. The error is, "The specified file could not be found. Check the name and path of the file."

Now, the file file does exist. I can open it in Excel with no errors or problems. When I select the file I use the browse button, find the file, and double click on it. This is when I receive the message. I have tries using two different computers with the same result. I have copied the file to my local HDD and had the same problem.

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 08-20-2017, 06:34 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,411
I have no idea what would cause this as a definitive answer, but
QB does not deal well with long path names

if the file name has spaces, or special characters, that can also cause issues

try copying the file to a parent directory and shortening the file name to all characters, no spaces or special characters
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 08:02 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.