Excell into access

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

 

[gls858]

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.

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

 

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