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
|