How do I import excel files to a new table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I want to import an excel worksheet into a new table and i am not
able to. I go to FILE---GET EXTERNAL DATA---IMPORT.
In the window that opens, at the bottom i select files of type(Microsoft
Excel.xls).
Then since i have the worksheet in my desk top i click on the desktop icon.
I select the worksheet and then i click on the import button.
I guess I'm expecting to see the new table under tables in access but i to
not see it.
I am new to access and not sure if I am doing this right.
Please somebody help!!!
 
hi,
the worksheet is not on you desk top. the icon is a short
cut to the worksheet which in on your hard disk.
don't try to get to the file from your desk top. brouse
to the file on the disk. from what you said, you did
everything correct except for the desk top part.
 
wrote:
*hi,
the worksheet is not on you desk top. the icon is a short
cut to the worksheet which in on your hard disk.
don't try to get to the file from your desk top. brouse
to the file on the disk. from what you said, you did
everything correct except for the desk top part.
Click to expand...



me too i want to import xls files to express administrator and i don
find any solutions please help me if you find a solution .Thank you


-
dodo200
 
Back
Top