<div>
Yep, they are some good options, ive just went with linked tables now!
</div>


Yep, they are some good options, ive just went with linked tables now!

<div>
Funny - I was just about to type up that you can also link the spreadsheet and use it in the same way as a staging table.<br />
<br />
FWIW, I prefer the import option -- largely personal preference, but I find that to be a more flexible approach.
</div>


Funny - I was just about to type up that you can also link the spreadsheet and use it in the same way as a staging table.

FWIW, I prefer the import option -- largely personal preference, but I find that to be a more flexible approach.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im loading excel data which has come from various data sources into an access database. The data types are not consistent, which means i keep getting paste errors on trying to paste into one master access table.<br />
<br />
Is there any way i can avoid this error or am i doing something wrong?<br />
<br />
Many thanks
</div>
</div>


Hi,

Im loading excel data which has come from various data sources into an access database. The data types are not consistent, which means i keep getting paste errors on trying to paste into one master access table.

Is there any way i can avoid this error or am i doing something wrong?

Many thanks

Loading excel data to access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.