When creating the linked table in MS Access is there any way to force column format to something else besides long text? Long text fields cannot be used with joins in MA Access.
I use the live data connector for a lot of Access work, and I have a local table that I dump everything into before anything else. So the user pushes a button that refreshes the local copy. The benefit to this approach is that you can build in some quality control to ensure that the user is working with the latest data.
But the local table and the append query are invisible to the user.
James thank you for the suggestion. I do something similar with make table queries in Access. The make table process allows me to format the long text fields to the proper format, they I use the formatted tables to join to our Data warehouse tables.
I have created a Data Shuttle upload, with no filters, to replace rows on my Smartsheet destination sheet. I discovered that all rows were not being added to the destination sheet. Debugging narrowed the problem down to the contents of one column. In Smartsheet, the column is formatted as Text/Number. In Excel for testing,…
We are considering upgrading to Advance, and I have questions about Bridge capabilities: Our project blueprint includes multiple reports that pull entries from master logs based on the job number. This means that our admins have to add the job number to every single new report filter when they set up a project. Can Bridge…
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.