import in Access 2007

[patti]

I amtrying to do a manual import of an excel file into access 2007.
I using Access 2007. The excel file is on server "t" and is being appened to
"Vendor" table. i get an error message: \\s\sales\sales.mdb is not a valid
path...etc.
I can run this import fine in access 2003. it's astraight import of excel
data into an existing table in my db. why is access 2007 involving this other
db in this procedure?

i have been researching this problem for a while and have not found any
info. Help!
i have reinstalled access 2007, have service pack 1, compacted and repaired
db, even made a copy & imported everything into new (copy of) this db and i
still get the error.

thanks

patti

 

[Klatuu]

You say the Excel file is on server t, but your error message is saying the
path to the mdb on server s is not valid. Are you using the
Transferspreadsheet method? Can you post the code you are using?

 

[patti]

the excel file path: S:\Urbn\fp\Vendor\vendor.xls

this is being done in access 2007, manual import of excel, data, appending
to existing Vendor table. i navigate to the file, click through "next", etc.
til "finish". then i get the error.
i have pointed to the correct file and do not understand why access is
going down the path to a another db.

 

[Klatuu]

Now I am really confused. In your original post, you used a UNC path
\\s\sales\sales.mdb
Now, you are using a drive map with a totally different file name
S:\Urbn\fp\Vendor\vendor.xls

I have no idea what you are doing.

 

[patti]

Klatuu,

Thanks for your patience and help. I 'm not sure which post you mean by
"original". i posted this issue 6 weeks ago with no resolution. i posted a
new message - and error has changed slightly.

I cannot fathom how that error message is being generated. i am doing a
manual import, navigating to my vendor.xls file. when i hit the finish
button, i get the invalid path error. i have no idea how the "sales" file is
coming into play. Why is access looking for this other file?

is this clearer? i navigate through the manual import in access 2007 to my
excel file. when i get to the final screen, i click "finish". it shoots out
an error to an unrelated file. there is no problem doing the same steps in
access 2003.

thanks.

 

[Stacie]

Patti,

I had the same problem when trying to manually import a budget template that
should have been the same for all my departments. The difference was that
one department added charts to his file and once he did that, I received the
path not valid message. Since it was only a short term project I copied the
sheet I was importing to another file and imported from there without any
problems.

 

[Klatuu]

I did not see the older one. This is in the thread where you posted on
9/14.

 

[patti]

In the orig 9/14 post, i did not incluude the path of the file i am
importing. you quoted the error message. the excel file i am importing is on
my t: drive and the error is throwing something about a db on my s: drive.

let me know if that makes the issue any clearer. in the meantime i will
research stacie's fix.

 

[Klatuu]

Actually, it was 9/12. But the problem I am having troulbe understanding is
that you are mixing drive letter mapping and UNC paths in the same question
and I am trying to be sure I understand.

Your original was
The excel file is on server "t" and is being appened to
"Vendor" table. i get an error message: \\s\sales\sales.mdb is not a valid
path

So on 9/12 you say it is the "t" server, and in this post you say "my t:
drive"
Now, this :
\\s\sales\sales.mdb
is a unc path, not a drive letter. So, which is it?
could it be that \\s\sales is mapped to your t: drive?

 

[patti]

thanks for your help and patience. doing a copy of the db via windows
explorer, opening it & doing a C&R, then renaming it has lead now lead to a
different error.

error message: " is not a valid name. Make
sure that it does not include invalid characters or punctuation and that it
is not too long. "
It has been posted previously:
(http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us)

i am going down the solutions suggested there. did run into a security
settings issue, which i posted under security.

thanks for all the insight.

patti