Error Importing Excel Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joy - 28 Mar 2007 23:54 GMT

When I am try and import date from a spreadsheet into an existing table, I
receive and error message and it will not import the data. I have check data
type and field names.

Thoughts

Reply to this Message

Jerry Whittle - 29 Mar 2007 15:54 GMT

And the error is? ;-)

Sometimes you need to make it a two-step process. Import the spreadsheet
into a new table then do an append query to move the data from the new table
to the existing table. Often this helps in finding problems.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> When I am try and import date from a spreadsheet into an existing table, I
> receive and error message and it will not import the data. I have check data
> type and field names.
>
> Thoughts

Reply to this Message