By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

table imported from excel says it's linked--to what?

P: 3
I'm totally self-taught, using access to try to make my job easier.

I created a table by importing an excel spreadsheet to make a new table.
Now I want to alter that table, and it won't let me, saying it is linked.
I looked under Relationships--no visible link.
I imported to save typing, but I need to add a primary key, and link it to another table.

Am I screwed, or just stupid?

thanks!
jenn

Sorry! Access 2003, windows XP
May 8 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,365
I'm totally self-taught, using access to try to make my job easier.

I created a table by importing an excel spreadsheet to make a new table.
Now I want to alter that table, and it won't let me, saying it is linked.
I looked under Relationships--no visible link.
I imported to save typing, but I need to add a primary key, and link it to another table.

Am I screwed, or just stupid?

thanks!
jenn

Sorry! Access 2003, windows XP
In the list of tables does it have a blue arrow to the left of it? If so then you linked the table from the spreadsheet, not imported.
May 8 '07 #2

P: 3
In the list of tables does it have a blue arrow to the left of it? If so then you linked the table from the spreadsheet, not imported.
It does, and i guess I did. It said "import" Is this something that happened because it was an excel sheet, or am i just approaching it bass-ackwards? (I blame my teacher!)
May 9 '07 #3

Rabbit
Expert Mod 10K+
P: 12,365
It does, and i guess I did. It said "import" Is this something that happened because it was an excel sheet, or am i just approaching it bass-ackwards? (I blame my teacher!)
You may want to retry it. File > Get External Data > Import
You may have just accidentally clicked the wrong option since Link is right below import. But it is possible to import an excel table into an Access table.
May 9 '07 #4

P: 3
Oh, geez, I guess, sometimes you just have to ask--I would have sworn I hit the right button--I did it 4 times!!, but I tried it again,and it's happy!!

thanks!
jenn
May 10 '07 #5

Rabbit
Expert Mod 10K+
P: 12,365
Oh, geez, I guess, sometimes you just have to ask--I would have sworn I hit the right button--I did it 4 times!!, but I tried it again,and it's happy!!

thanks!
jenn
Not a problem, good luck.
May 10 '07 #6

NeoPa
Expert Mod 15k+
P: 31,487
It does, and i guess I did. It said "import" Is this something that happened because it was an excel sheet, or am i just approaching it bass-ackwards? (I blame my teacher!)
Great attitude and humour :) (I guess the bass-ackwards wasn't about any fish.)
I was pleased to see you got sorted in the end anyway.

PS. I was self-taught too, but my teacher was brilliant :D
May 11 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.