MS Excel TO MS Access

[Lokesh]

Hi, I am new to MS Access. Currently I am Working on Excel Sheet, Currently I
am working on a database with company on contact details in a single excel
sheet, but day by day the data is also increasing and the excel crashes
often. If I have to start Access how do I start? I am not able to judge from
where I start. Do I need to create a table first of write a query first.

 

[burningthemidniteoil]

Open MS access application. And then from the main menu File->Get
External Data->Import
this will start a wizard which will put it into a table for you -
alternatively
File->Get External Data->Iink which will link to the spreadsheet
rather than take a copy ..

 

[burningthemidniteoil]

Oh forgot to say you have to create a new database. Open Access
application then File -> New, Select 'blank database' on right. Then
create db1
then File -> Get External Database -> Import as suggested..

 

[Peter Hibbs]

It depends on how your spreadsheet is laid out and what data it
contains. If you can have more than one contact name for a company
then you will need at least two tables, one to hold the company
information and one to hold the contacts information. The two tables
will need to be linked with a 1 to Many relationship.

Importing the data from the spreadsheet into two tables and keeping
the correct contacts linked to the correct companies can be tricky but
the Excel to Access Converter utility program at :
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d
may be able to do it for you automatically.

If you are new to Access then perhaps you should read up on Relational
Database Design first, there are plenty of Web sites that can help
with this.

HTH

Peter Hibbs.

 

[Annemarie]

Hi, I am new to MS Access. Currently I am Working on Excel Sheet,
Currently I
am working on a database with company on contact details in a single excel
sheet, but day by day the data is also increasing and the excel crashes
often. If I have to start Access how do I start? I am not able to judge
from
where I start. Do I need to create a table first of write a query first.

 

[Lokesh]

It depends on how your spreadsheet is laid out and what data it
contains. If you can have more than one contact name for a company
then you will need at least two tables, one to hold the company
information and one to hold the contacts information. The two tables
will need to be linked with a 1 to Many relationship.

Importing the data from the spreadsheet into two tables and keeping
the correct contacts linked to the correct companies can be tricky but
the Excel to Access Converter utility program at :
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d
may be able to do it for you automatically.

If you are new to Access then perhaps you should read up on Relational
Database Design first, there are plenty of Web sites that can help
with this.

HTH

Peter Hibbs.

hi Peter,

Thanx, i have 3 sets of information in my database thats 1,Company details -
Address and Phone Number 2,COntact Detail - Name, Designation, Email id and
Phone Number. 3 campaign details done on those contact. so do i need to have
3 tables

 

[Peter Hibbs]

Lokesh,

If any one contact can have more than one campaign then yes, you would
have a relationship of One to Many between contacts and campaigns. The
Converter program I mentioned can handle that as well.

If a contact only ever has one campaign then you could just add a
field to the Contacts table to store that information. Without knowing
more about your data it is difficult to be more precise.

HTH

Peter Hibbs.

 

[John W. Vinson]

Hi, I am new to MS Access. Currently I am Working on Excel Sheet, Currently I
am working on a database with company on contact details in a single excel
sheet, but day by day the data is also increasing and the excel crashes
often. If I have to start Access how do I start? I am not able to judge from
where I start. Do I need to create a table first of write a query first.

You're getting some good advice. Just one warning: Excel is a spreadsheet,
best of the breed; Access is NOT a spreadsheet, it's a relational database
programming environment. *They are very different* and require a different
mindset and different type of programming.

Here are some resources to get you started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials