Populating an access table with data from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data entered on excel which I want to use to populate an access table.
Is there any way I can do this without having to re type it all?
 
You can import an Excel file with:
File | Get External | Import
 
I have data entered on excel which I
want to use to populate an access table.
Is there any way I can do this without
having to re type it all?
Click to expand...

Whether you can successfully populate an Access Table with spreadsheet data
will depend on the data... if it is tabular (row and column) data, that will
be simple; if you have one of those spreadsheets where every cell is
essentially independent or calculated, then it may not be simple at all.

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create New Table/Column 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Creating an Excel Spreadsheet from Access 1
Access #Error & Excel Pivot 0
Getting information from access table in excel 1
Please help - I need to separate data to two tables using one form. 0
Excel Custom trendlines and R^2 values 0

Back
Top