Excell into access

  • Thread starter Thread starter Chris
  • Start date Start date
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.
 
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
 
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.
 
Back
Top