improrting Excel Spreadsheets to Access XP

P

Pete

When I import an Excel Spreadsheet to and Access XP
database. The dates that appear in Excel as 6/7/04. Will
appear in the Access import spreadsheet wizard as 7/6/04
00:00:00. Also when the above happens the "Where would
you like to store data? In Existing Table:" is greyed out.

If you go throught the whole wizard and say Finish then
the date appears in the Table in the format of 6/7/2004.

I would like to be able to add these imports to existing
tables. Is there a seeting in Access that I need to
change?

Thanks in Advance
Pete
 
J

John Nurick

Hi Pete,

To import to an existing Access table, the first row of the Excel table
must contain field names and you must check "First row contains column
headings" in the spreadsheet import wizard.
 

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

Import Excel 2010 table into Access 2010 - not listed as range 0
Import Custom # From Excel 2007 to Access 2007 as txt 1
How to import Start/Finish Data from Excel 1
Time format hh:nn drops leading zero 0
Office 2003 -> Office 2007: Import Data fr Access into Excel 0
Trying to use "Import Spreadsheet Wizard" in Access 2
Importing Excel Spreadsheet into Access 3
Sorting a block of page number citations 4

Top