A
AMDGUY [MCP]
How do I import an excel worksheet in to an access table
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Whilst in Access and assuming you have a file created to bring it into:-
File / Get External data / Import / Change 'Files of type' to Excel using
the dropdown and then hit Import.
File / Get External data / Import / Change 'Files of type' to Excel using
the dropdown and then hit Import.
A
AMDGUY [MCP]
Tried that It didnt work
K
Ken Wright
So what did happen when you did that?
A
AMDGUY [MCP]
Import Spreadsheet Wizard
An error occurred trying to import the file 'c:\bla bla\CAF-Dec.xls The
file was not imported.
Thats all it gives me
An error occurred trying to import the file 'c:\bla bla\CAF-Dec.xls The
file was not imported.
Thats all it gives me
A
AMDGUY [MCP]
I can send you the 2 files
K
Ken Wright
Are you trying to import into an existing table or as a new sheet?
Is it just this file that won't work, or can you import other files/sheets?
Is it just this file that won't work, or can you import other files/sheets?
K
Ken Wright
OK, remove the NOSPAM bit from my email addy - tell me which sheet you are
trying to import, and also what version Access you are using?
trying to import, and also what version Access you are using?
A
AMDGUY [MCP]
Tryed to e-mail you but it didnt work. Told me wrong addy after i
removed the nospam
removed the nospam
A
AMDGUY [MCP]
Its access 2003
and excel 2003
Try ing to import the CAF sheet in to the DATA table
and excel 2003
Try ing to import the CAF sheet in to the DATA table
K
Ken Wright
ken dot wright at ntlworld.com
N
Nick Hodge
I always go about this a totally different way.
In Access go to File>Get external data>Link tables...
In the dialog, select 'files of type' as Excel and navigate to your Excel
file, select the sheet, range, etc to link and then it will sit as a pseudo
table and can be used throughout Access's UI.
I prefer this method, tend to do a swift 'Make Table Query' make an access
table from the Excel and Voila!. You can of course also set up an update,
append or any other type of action query.
It takes one key press to delete the link too ;-)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
In Access go to File>Get external data>Link tables...
In the dialog, select 'files of type' as Excel and navigate to your Excel
file, select the sheet, range, etc to link and then it will sit as a pseudo
table and can be used throughout Access's UI.
I prefer this method, tend to do a swift 'Make Table Query' make an access
table from the Excel and Voila!. You can of course also set up an update,
append or any other type of action query.
It takes one key press to delete the link too ;-)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)