Uploading Data from an Excel file to an Access table

[Rizk]

I'm trying to load data from an excel spreadsheet into an Access table. I've created a button on a form to try and do this through code and am running into issues. Can you help?

 

[RickSpr]

Yes, we can probably help. Provide some details. "Running into issues" is too vague. Rick Sprague

 

[Quehay]

I have to do this all the time. I really wouldn't want to try and automate it with a button because you can get such junky data coming from Excel--you'll have an ImportErrors table full of things that didn't make the transfer. I always manually groom the Excel sheet and make sure that the data types for the columns are correct, then import into a temp table and do an append query. You can get import headaches if there are zero length strings in the Excel sheet and your fields are set to not allow them.