import excel data

U

uuhhgg

I know that you can make a table in access through excel but is there a way
to copy and paste data from excel to access? Or is it possible to add data
to an access table from excel

thanks in advance
 
M

mray29

You can copy cells in Excel and paste them directly into a table in Datasheet
mode in Access, if that's what you're after. You can also link an Excel
spreadsheet into an Access database, just as if it were an Access table. You
can then create a query based on the spreadsheet link and use an append query
to add records to an Access table.
 
Top