SQL Server SQL Table Columns Missing When Imported Into Access

gcuhipw9 于 2023-03-22 发布在其他

关注(0)|答案(1)|浏览(129)

I have a table that lives in SQL Server, I imported the table into Access through External Data > New Data Source > From Database. I went through the whole authentication process. After choosing the correct Database and table that I wanted imported, most columns in the table were imported, but some were not. Why would some columns be missing?

I am using SQL Server Management Studio v18.12.1.

I tried checking to see if these missing columns were computed columns, but that shows False in SQL Server.

sql-server

来源：https://stackoverflow.com/questions/75761598/sql-table-columns-missing-when-imported-into-access

1条答案

按热度按时间

2exbekwf1#

Microsoft Access has a limit of 255 columns per table. If you attempt to link to an external table that has more than 255 columns, Access will retrieve the first 255 columns only. https://www.easysoft.com/blog/access-column-limit.html

My work around was creating a new table in SQL Server with the columns that I needed and importing that table instead.

赞(0）回复(0）举报 2023-03-22

我来回答

SQL Server SQL Table Columns Missing When Imported Into Access

1条答案

相关问题

热门标签

最新问答