import excel data

[Guest]

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

 

[Guest]

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.

 

[Joseph Meehan]

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

I have not tried it, but I believe that you could link to the data in
the Excel spreadsheet and us an append query to add it.

 

[Guest]

Will I be able to have more than 65536 records if I use a linked table?

 

[Joseph Meehan]

Will I be able to have more than 65536 records if I use a linked
table?

That depends on what version of Excel you are using.