Import error importing QB 2005 Premier


W

Wes VanAlstyne

When I try to import data from QB 2005 Premier I receive the following error:
The process cannot access the file c:\QBData\nnn.qbw because its being used
by another process.

I have downloaded the latest SP1 and transaction level update. I am trying
to import all data from QB 2005. I do have QB running on the same computer
and I went through the process of letting the SBA access the data. Did I do
something wrong?
 
Ad

Advertisements

W

Wes VanAlstyne

OK, Now that I have that figured out, I cannot import all my detail records
because the database in QB is larger than what SBA will accept. What are the
limitations on the SBA database? I have detail data going back mid 1995.
It's all in QB...shouldn't it also fit into SBA? We only record total amounts
for each invoice, therefore, no detail data is in QB.
 
S

SBA Team

Could you post the exact error/warning message you received ?

Srinivas
 
W

Wes VanAlstyne

OK, It took a long time for the error message to appear. Anyway, here it is:

*** Start of message in dialog box ***

The number of transactions in your file exceeds the import limits. These
transactions must be condensed.

To reduce the number of transactions in the file you want to migrate, do one
or both of the following:

1. Close Small Business Accounting and open QuickBooks. Archive and condense
your data using the Arhive & Condense Wizard. After condensing the
transactions, reopen Small Buiness Accounting and restart the Migration
Wizard.

2. Restart the Migration Wizard and define your fiscal years to reduce the
number of transactions you want to bring into Small Buiness Accounting.

*** End of message

As a test, I tried to import from 2003 thru 2005 and it succeded, however,
the customer balances are incorrect because all data for each customer older
than 2003 was not imported.
 
S

SBA Team

As a test, you may try to copy your QB company file, open the copy in QB,
archive and condense old transactions, and import all transactions into SBA.
That should bring transactions as well as balances.
 
Ad

Advertisements

T

Tommy

Hello SBA Team, I am having a similar problem. I am able to migrate QB
2003 data but I can't migrate QB 2004 data. The 2003 data doesn't have
security activated for the QBW file. The 2004 QB file does require
security to log on. That is really the only difference between the two
files. I've rebuilt the 2004 data several times but when I attempt to
migrate "ALL DATA" I get the same error..."The selected file is not
valid. You must select another file." I seem to be the only one with
this problem....HELP!!!
 
S

Shane Nelson

Hello,
Thank you for submitting your SBA question for the group.

Due to the complexity of this issue, could you please contact Microsoft
Office Small Business Accounting Support at 1-800-642-7676 option 2. When
you call the 1-800 number, you will be asked to supply your PID. This PID
will entitle you to 2 free support incidents, if you have already used your
incidents you will be charge for the support call.

Shane Nelson
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security
=============================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============================================
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Date: Mon, 10 Oct 2005 15:36:27 -0600
From: Tommy <[email protected]>
Subject: Re: Import error importing QB 2005 Premier

Hello SBA Team, I am having a similar problem. I am able to migrate QB
2003 data but I can't migrate QB 2004 data. The 2003 data doesn't have
security activated for the QBW file. The 2004 QB file does require
security to log on. That is really the only difference between the two
files. I've rebuilt the 2004 data several times but when I attempt to
migrate "ALL DATA" I get the same error..."The selected file is not
valid. You must select another file." I seem to be the only one with
this problem....HELP!!!
 
G

Gerd

One thing I can think of is the file name of your QB file. My QB was names hina's.qbw which caused the same error message. Changing it to hinas.qbw resolved my problem.
Hello SBA Team, I am having a similar problem. I am able to migrate QB 2003 data but I can't migrate QB 2004 data. The 2003 data doesn't have security activated for the QBW file. The 2004 QB file does require security to log on. That is really the only difference between the two files. I've rebuilt the 2004 data several times but when I attempt to migrate "ALL DATA" I get the same error..."The selected file is not valid. You must select another file." I seem to be the only one with this problem....HELP!!!

SBA Team wrote:

As a test, you may try to copy your QB company file, open the copy in QB,
archive and condense old transactions, and import all transactions into SBA.
That should bring transactions as well as balances.


OK, It took a long time for the error message to appear. Anyway, here it
is:
*** Start of message in dialog box ***

The number of transactions in your file exceeds the import limits. These
transactions must be condensed.

To reduce the number of transactions in the file you want to migrate, do
one
or both of the following:

1. Close Small Business Accounting and open QuickBooks. Archive and
condense
your data using the Arhive & Condense Wizard. After condensing the
transactions, reopen Small Buiness Accounting and restart the Migration
Wizard.

2. Restart the Migration Wizard and define your fiscal years to reduce the
number of transactions you want to bring into Small Buiness Accounting.

*** End of message

As a test, I tried to import from 2003 thru 2005 and it succeded, however,
the customer balances are incorrect because all data for each customer
older
than 2003 was not imported.

:

Could you post the exact error/warning message you received ?

Srinivas

message
OK, Now that I have that figured out, I cannot import all my detail
records
because the database in QB is larger than what SBA will accept. What
are
the
limitations on the SBA database? I have detail data going back mid
1995.
It's all in QB...shouldn't it also fit into SBA? We only record total
amounts
for each invoice, therefore, no detail data is in QB.

:

You should exit QB before starting the import process.

message
When I try to import data from QB 2005 Premier I receive the
following
error:
The process cannot access the file c:\QBData\nnn.qbw because its
being
used
by another process.

I have downloaded the latest SP1 and transaction level update. I am
trying
to import all data from QB 2005. I do have QB running on the same
computer
and I went through the process of letting the SBA access the data.
Did
I
do
something wrong?
 
T

Tommy

Thank you.
Hello,
Thank you for submitting your SBA question for the group.

Due to the complexity of this issue, could you please contact Microsoft
Office Small Business Accounting Support at 1-800-642-7676 option 2. When
you call the 1-800 number, you will be asked to supply your PID. This PID
will entitle you to 2 free support incidents, if you have already used your
incidents you will be charge for the support call.

Shane Nelson
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security
=============================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============================================
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Date: Mon, 10 Oct 2005 15:36:27 -0600
From: Tommy <[email protected]>
Subject: Re: Import error importing QB 2005 Premier

Hello SBA Team, I am having a similar problem. I am able to migrate QB
2003 data but I can't migrate QB 2004 data. The 2003 data doesn't have
security activated for the QBW file. The 2004 QB file does require
security to log on. That is really the only difference between the two
files. I've rebuilt the 2004 data several times but when I attempt to
migrate "ALL DATA" I get the same error..."The selected file is not
valid. You must select another file." I seem to be the only one with
this problem....HELP!!!

SBA Team wrote:
 
Ad

Advertisements

B

Brwnize1

Hi Tommy,

I got the File Not Valid error as well. Read a post on here about
rebuilding data in QB (company has to be closed to access this option under
the Utilities Menu in QB) and disabling any anti-virus or anti-spyware
programs. I disabled Norton long enough to try the import again AFTER
rebuilding QB data...worked like a charm. Not sure which was the offending
culprit, but am running along fine now. Hope this helps.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top