Excell into access

C

Chris

hello all.

I am changing a system from using excel into using access. All the info
from the spreadsheet needs to be inputed into access.

How would I do this?

please don't say copy & paste - there's too much Data.
 
G

gls858

Chris said:
hello all.

I am changing a system from using excel into using access. All the info
from the spreadsheet needs to be inputed into access.

How would I do this?

please don't say copy & paste - there's too much Data.
Click to expand...
In Access you can go to File > Get External Date > Import
This will allow you to import the data from Excel. How well
this works depends on the data and how it's laid out in Excel.
It may be that all you need to do is link to the spreadsheet.
More detail would help.

gls858
 
G

Guest

hi,
in access:
File>get exteranl Data>import
set file of type to excel. brouse to the files you wish to
import.
follow the wizard.
 
Top