Import Spreadsheet Wizard

[Guest]

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the last step.
When I press [Finish] I get the following message...

I know the file exists and it is not open at the time I tried to import it.
Is there anything else I should be doing to import this spreadsheet?

 

[Ken Snell \(MVP\)]

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data contain
a primary key field that is not the last field in the table, and the file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append query
to copy the data to the existing table. You then can delete the "new" table.

--
Ken Snell
<MS ACCESS MVP>

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the last
step.
When I press [Finish] I get the following message...

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Ken Snell \(MVP\)]

One other possibility - is the worksheet itself protected?

--

Ken Snell
<MS ACCESS MVP>

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data contain
a primary key field that is not the last field in the table, and the
file's spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The file
was not imported.>>

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Guest]

Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data contain
a primary key field that is not the last field in the table, and the file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append query
to copy the data to the existing table. You then can delete the "new" table.

--
Ken Snell
<MS ACCESS MVP>

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The file
was not imported.>>

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Ken Snell \(MVP\)]

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>

Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Guest]

The wizard will not create the new table.
It goes through all of the steps without a problem until the last step and I
get the same message beow.

I have tried with and without a primary key.
no success.

It works in a .mdb file but not in a .adp file?
I would like to create a link in an .adp file so that the link is active in
the project.
The .mdb file seems to be a static representation.
This does not work for my application.

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>

Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>



I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Ken Snell \(MVP\)]

I have not worked with .adp files, so my knowledge may not be useful for
your setup. However, from Google searches, it appears that you can import
EXCEL data to such files, so that is not the problem itself. And I'm not
finding information in previous posts that might shed light on your problem.

I continue to think that there is some problem with the format of the EXCEL
spreadsheet vs. the table, or there is a problem with the data in the EXCEL
sheet, or similar issues to what I've already raised. Other than to suggest
that you very carefully go through the EXCEL's data and ensure that there
are no problems with them, I don't have more ideas right now.

I'll ask some other MVPs with .adp experience to take a look at this thread;
perhaps one of them might have some ideas.
--

Ken Snell
<MS ACCESS MVP>


..

The wizard will not create the new table.
It goes through all of the steps without a problem until the last step and
I
get the same message beow.

I have tried with and without a primary key.
no success.

It works in a .mdb file but not in a .adp file?
I would like to create a link in an .adp file so that the link is active
in
the project.
The .mdb file seems to be a static representation.
This does not work for my application.

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table
to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail
because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>

Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?



:

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type
of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a
new
table, and let the import wizard create the table for me. Then I use
an
append query to copy the data from that new table into an existing
table.
This allows me complete control over which fields map to which, over
the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>



I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to
import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[Ken Snell \(MVP\)]

You also may want to post your question in
microsoft.public.access.adp.sqlserver newsgroup. Responders in that group
will have more experience with .adp files.

--

Ken Snell
<MS ACCESS MVP>

I have not worked with .adp files, so my knowledge may not be useful for
your setup. However, from Google searches, it appears that you can import
EXCEL data to such files, so that is not the problem itself. And I'm not
finding information in previous posts that might shed light on your
problem.

I continue to think that there is some problem with the format of the
EXCEL spreadsheet vs. the table, or there is a problem with the data in
the EXCEL sheet, or similar issues to what I've already raised. Other than
to suggest that you very carefully go through the EXCEL's data and ensure
that there are no problems with them, I don't have more ideas right now.

I'll ask some other MVPs with .adp experience to take a look at this
thread; perhaps one of them might have some ideas.
--

Ken Snell
<MS ACCESS MVP>


.

The wizard will not create the new table.
It goes through all of the steps without a problem until the last step
and I
get the same message beow.

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file was not imported.>>

I have tried with and without a primary key.
no success.

It works in a .mdb file but not in a .adp file?
I would like to create a link in an .adp file so that the link is active
in
the project.
The .mdb file seems to be a static representation.
This does not work for my application.

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table
to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail
because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>


Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?



:

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type
of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a
new
table, and let the import wizard create the table for me. Then I use
an
append query to copy the data from that new table into an existing
table.
This allows me complete control over which fields map to which, over
the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an
append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>



I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to
import
it.
Is there anything else I should be doing to import this
spreadsheet?

 

[Ken Snell \(MVP\)]

A fellow MVP has suggested that it may be a problem with security settings
on the SQL server backend file -- do you have the "authority" to create new
tables?

--

Ken Snell
<MS ACCESS MVP>

I have not worked with .adp files, so my knowledge may not be useful for
your setup. However, from Google searches, it appears that you can import
EXCEL data to such files, so that is not the problem itself. And I'm not
finding information in previous posts that might shed light on your
problem.

I continue to think that there is some problem with the format of the
EXCEL spreadsheet vs. the table, or there is a problem with the data in
the EXCEL sheet, or similar issues to what I've already raised. Other than
to suggest that you very carefully go through the EXCEL's data and ensure
that there are no problems with them, I don't have more ideas right now.

I'll ask some other MVPs with .adp experience to take a look at this
thread; perhaps one of them might have some ideas.
--

Ken Snell
<MS ACCESS MVP>


.

The wizard will not create the new table.
It goes through all of the steps without a problem until the last step
and I
get the same message beow.

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file was not imported.>>

I have tried with and without a primary key.
no success.

It works in a .mdb file but not in a .adp file?
I would like to create a link in an .adp file so that the link is active
in
the project.
The .mdb file seems to be a static representation.
This does not work for my application.

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table
to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail
because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>


Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?



:

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type
of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a
new
table, and let the import wizard create the table for me. Then I use
an
append query to copy the data from that new table into an existing
table.
This allows me complete control over which fields map to which, over
the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an
append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>



I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to
import
it.
Is there anything else I should be doing to import this
spreadsheet?

 

[Sylvain Lafontaine]

Importing or linking a file? It's not clear from your post what you are
trying to do.

Linking a file will cause you trouble if you try this on a remote server
because the JET OLEDB won't work over the Internet: the SQL-Server must be
on your local machine or on a local LAN and in the second case have
sufficient permission to access the files on your machine. Any firewall
could also block the operation.

You must also have sufficient permission to create a linked server or a view
on the SQL-Server.

Some strange format in the Excel could also be the cause of your problem;
you should make a test with a simple file and simple data.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

The wizard will not create the new table.
It goes through all of the steps without a problem until the last step and
I
get the same message beow.

I have tried with and without a primary key.
no success.

It works in a .mdb file but not in a .adp file?
I would like to create a link in an .adp file so that the link is active
in
the project.
The .mdb file seems to be a static representation.
This does not work for my application.

You import the spreadsheet into a new table (the wizard can do this for
you). Then you use an append query to copy the data from that new table
to
your permanent table.

You note that the spreadsheet has a primary key column in it. By chance,
does the data that you are importing contain any primary key values that
already exist in the table? If yes, the data importation will fail
because a
duplicate value for the primary key will result.
--

Ken Snell
<MS ACCESS MVP>

Thx Ken.
Still no success.

file is not pswd prtctd.
file is not currpt.
pri key is the first column.
I am trying to copy to a new table.

I am a little confused about the query...
If I can't import the file how do I append a query to it?



:

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data
contain
a primary key field that is not the last field in the table, and the
file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type
of
the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a
new
table, and let the import wizard create the table for me. Then I use
an
append query to copy the data from that new table into an existing
table.
This allows me complete control over which fields map to which, over
the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append
query
to copy the data to the existing table. You then can delete the "new"
table.

--
Ken Snell
<MS ACCESS MVP>



I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the
last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The
file
was not imported.>>

I know the file exists and it is not open at the time I tried to
import
it.
Is there anything else I should be doing to import this spreadsheet?

 

[jn]

Could be any number of possibilities, unfortunately:

Is the workbook file password protected?

Is the file corrupted?

Does the table into which you're wanting to import the data contain
a primary key field that is not the last field in the table, and the file's
spreadsheet does not contain that primary key in a column?

Do any of the data in the EXCEL file not match the data type of the
field into which you want to import the data?

When I need to import a spreadsheet, I will usually import it into a new
table, and let the import wizard create the table for me. Then I use an
append query to copy the data from that new table into an existing table.
This allows me complete control over which fields map to which, over the
format of the data as I put the data in the permanent table, etc.

Try importing and choose the "new table" option. Then create an append query
to copy the data to the existing table. You then can delete the "new" table.

--
Ken Snell
<MS ACCESS MVP>

I am having trouble importing an .xls into an access project.
I am following the steps in the Import Spreadsheet Wizard until the last
step.
When I press [Finish] I get the following message...

An Error occured trying to import 'C:\temp\RSLINX DDE\T4.xls'. The file
was not imported.>>

I know the file exists and it is not open at the time I tried to import
it.
Is there anything else I should be doing to import this spreadsheet?