Importing in Access XP

  • Thread starter Thread starter MadCrazyNewbie
  • Start date Start date
M

MadCrazyNewbie

Hey Group,

How could I import a Data from a Excel Spreadsheet, into a Already Exsiting
Table, also can I choose which coloum(s) need what row of data in?

Many Thanks
MCN
 
Try linking the spreadsheet (File|Get External Data|Link). Then, with the
spreadsheet linked, you can create an Append Query using the linked
spreadsheet. An Append Query will allow you to specify exactly which
fields from the linked spreadsheet will be appended to fields in your table.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing data from excel spreadsheet 1
I'm trying to import an Excel spreadsheet into an exsiting table.. 5
Need an example of importing from Excel to Access 3
importing data from Excel 4
Printing a DS or Database 2
Printing 1
Access Subscript out of range when importing into access 2010 from excel 0

Back
Top