software

I have Office 2000 and would like to know how to convert an MS Excel
worksheet to my MS Access database.Without more information to go on.....

Open MS Access
Filegt;Get External Datagt;Import Data
Select your Excel file...then follow the prompts.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;HelpJimquot; wrote:

gt; I have Office 2000 and would like to know how to convert an MS Excel
gt; worksheet to my MS Access database.
gt;

Thanks for your help. I believe the problem was all headings have to be
identical or info will not export/import.

Jim

quot;Ron Coderrequot; wrote:

gt; Without more information to go on.....
gt;
gt; Open MS Access
gt; Filegt;Get External Datagt;Import Data
gt; Select your Excel file...then follow the prompts.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;HelpJimquot; wrote:
gt;
gt; gt; I have Office 2000 and would like to know how to convert an MS Excel
gt; gt; worksheet to my MS Access database.
gt; gt;


You can also copy and paste directly into a Table in ACCESS as long as
you have the same amount of columns in ACCESS as you have copied from
EXCEL. Sometimes it is easiest if all the fields in ACCESS are text
then it will accept the data a little more easier. If it doesn't accept
all of the data ACCESS will generate another table with the information
it wasn't able to import.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=497149Thank you very much. This was my first experience with a message board. I
am very impressed with the prompt response from you guys. Until next
time..Have a blessed and prosperous New Year.
Jim

quot;wjohnsonquot; wrote:

gt;
gt; You can also copy and paste directly into a Table in ACCESS as long as
gt; you have the same amount of columns in ACCESS as you have copied from
gt; EXCEL. Sometimes it is easiest if all the fields in ACCESS are text
gt; then it will accept the data a little more easier. If it doesn't accept
gt; all of the data ACCESS will generate another table with the information
gt; it wasn't able to import.
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=497149
gt;
gt;

Ron,
I would like to give credit as an snswered question to you and Johnson.
however I am unable to locate the info from HELP...In the message pane, do
one of the following:
If the post answers your question, click Yes next to Did this post answer
the question
Where is the YES LOCATED? Thank you very much and have a blessed and Happy
New Year.
Jimquot;Ron Coderrequot; wrote:

gt; Without more information to go on.....
gt;
gt; Open MS Access
gt; Filegt;Get External Datagt;Import Data
gt; Select your Excel file...then follow the prompts.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;HelpJimquot; wrote:
gt;
gt; gt; I have Office 2000 and would like to know how to convert an MS Excel
gt; gt; worksheet to my MS Access database.
gt; gt;

If you view forum posts via the MS website below, the message pane has
buttons for rating responses.
(I'm not sure if any of the newsreaders include that functionality.)

www.microsoft.com/office/comm...verview.mspx#2

***********
Best Regards,
Ron

XL2002, WinXP-Proquot;HelpJimquot; wrote:

gt; Ron,
gt; I would like to give credit as an snswered question to you and Johnson.
gt; however I am unable to locate the info from HELP...In the message pane, do
gt; one of the following:
gt; If the post answers your question, click Yes next to Did this post answer
gt; the question
gt; Where is the YES LOCATED? Thank you very much and have a blessed and Happy
gt; New Year.
gt; Jim
gt;
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Without more information to go on.....
gt; gt;
gt; gt; Open MS Access
gt; gt; Filegt;Get External Datagt;Import Data
gt; gt; Select your Excel file...then follow the prompts.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;HelpJimquot; wrote:
gt; gt;
gt; gt; gt; I have Office 2000 and would like to know how to convert an MS Excel
gt; gt; gt; worksheet to my MS Access database.
gt; gt; gt;