importing data from excel

[Guest]

I have not had success importing dates from excel to Access. Though the
dates are formatted as such in both applications, when I enter the importing
wizard the dates in the sample data from excel show up as though they are
text rather than dates. Can anyone help me?

 

[Guest]

Try building a table with the correct fields and then append.

 

[Guest]

Hi Karl,
this is something I have rolled out to many of our users who have a
requirement to exchange data between various databases, including Access, and
Excel spreadsheets. I dont know about the wizards as I have never used them
but have never had any trouble with dates or any other data for that matter
using the ADO libraries. We usually execute the transfer from Excel but it is
essentially the same task importing from an Access module. In the module set
a reference to ADO ..connect to the data source .. create a recordset, pass
the Excel data to the recordset .. write the data to the database using
addnew method. Hope that helps