ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Microsoft Query (https://www.excelbanter.com/excel-discussion-misc-queries/10088-microsoft-query.html)

R Ormerod

Microsoft Query
 
I am importing a query from Access into Excel using Data = Get External Data.

In the Microsoft Query wizard when I select this particular query I am
getting the following error message:

'String data, right truncated on column number 4 (COLUMN_NAME)'

There are many other queries which I have successfully imported from this
database and I cannot see any differences.

Any ideas?

Regards
--
R Ormerod


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com