G Guest May 12, 2004 #1 Can anyone advise on how I can import and excel spreadsheet in to an access database? Any information would be helpful
Can anyone advise on how I can import and excel spreadsheet in to an access database? Any information would be helpful
G Guest May 15, 2004 #3 With your database open and objects menu open, click on File|Get External Data|Import. The column headings in Excel must be exactly as your field names if you want to add to an existing table.
With your database open and objects menu open, click on File|Get External Data|Import. The column headings in Excel must be exactly as your field names if you want to add to an existing table.
