View Single Post
  #2  
Old April 26th, 2004, 02:08 PM
Cheryl Fischer
external usenet poster
 
Posts: n/a
Default Importing in Access XP

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.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"MadCrazyNewbie" wrote in message
...
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