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.
 
Back
Top