Convert MS Excel data to MS Access database

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
File>Get External Data>Import 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
> File>Get External Data>Import 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.

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
> File>Get External Data>Import 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
> > File>Get External Data>Import 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.
> > >