Append Excel records to an Access table

[dwilliams]

Hi,

I have Office 2010 working on XP Pro SP3.

This is the first time I have tried to append/import a bunch of names and addresses from a spreadsheet into my access table.

I thought it would be easy with all the integration of applications but it's not. What happened to the bit where I could match the fields where it's not quite the same name and set the type so it worked OK.

All I seem to be able to get at at the moment is a wizard which does a very poor job and won't allow me to append the records. I tried exporting the Excel as CSV - same thing - error messages.

Is there a way of matching up the fields so everything works? What am I missing - this should be a cinch right?

Cheers

Dave

 

[John Big Booty]

Rather than trying to import your Excel/CSV file directly into your working tables you might be better off importing it into a temporary table where you can "massage" the data before appending it to your working tables.

The sample here demonstrates the sort of thing I'm talking about.

 

[dwilliams]

Rather than trying to import your Excel/CSV file directly into your working tables you might be better off importing it into a temporary table where you can "massage" the data before appending it to your working tables.

That worked a treat so thanks for that. I imported into a new table and ran a simple append query that allowed me to match the fields. Thanks for your help

Dave

 

[John Big Booty]

Good work glad I could help