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
FileGet External DataImport Data
Select your Excel file...then follow the prompts.

Does that help?

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

XL2002, WinXP-Pro


"HelpJim" wrote:

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

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

Jim

"Ron Coderre" wrote:

Without more information to go on.....

Open MS Access
FileGet External DataImport Data
Select your Excel file...then follow the prompts.

Does that help?

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

XL2002, WinXP-Pro


"HelpJim" wrote:

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

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: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497149

Thank 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

"wjohnson" wrote:


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: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497149

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.
Jim


"Ron Coderre" wrote:

Without more information to go on.....

Open MS Access
FileGet External DataImport Data
Select your Excel file...then follow the prompts.

Does that help?

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

XL2002, WinXP-Pro


"HelpJim" wrote:

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

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.)

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

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

XL2002, WinXP-Pro


"HelpJim" wrote:

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.
Jim


"Ron Coderre" wrote:

Without more information to go on.....

Open MS Access
FileGet External DataImport Data
Select your Excel file...then follow the prompts.

Does that help?

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

XL2002, WinXP-Pro


"HelpJim" wrote:

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