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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jashelle - 31 Aug 2004 03:41 GMT

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

Reply to this Message

GVaught - 31 Aug 2004 06:04 GMT

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.

Signature

G Vaught

> 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
[quoted text clipped - 4 lines]
> for me to use access if this is not achievable.
> any help greatly appreciated

Reply to this Message