How do i copy lists of information into fields in Access instead .

[jashelle]

Hi I've created a database in excel, with student names. I want to copy a
whole list over from an excel spreadsheet, but when i put the cursor in the
first field it won't copy it across. i have to type them in individually.
Does anyone know how to copy lists across?? it isn't time or cost effective
for me to use access if this is not achievable.
any help greatly appreciated

 

[GVaught]

Although you can copy and paste data from Excel into an existing table, it
is not the recommend method. Try importing the data through File | Get
External Data | Import. You could also link in the Excel spreadsheet, which
would be updateable either from Access or Excel.