Formatting Linked Excel File

  • Thread starter Thread starter benbanyas
  • Start date Start date
B

benbanyas

I swear I posted this question yesterday but I can't find the thread for the
life of me.
I have a linked imported excel file that displays on a form. There is only
one column in the Excel file of words I need to keep in alphabetical order.
Is there any way I can format it to be viewed on the Access form in mulitple
columns instead of one very long column without having to change it in Excel?
 
Why would you want to do this?

You can always base the form on a query and filter the records by first
letter using a text box
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Unlink open excel files 2
VBA- Excel Programming:- 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Excel Macro for deleting Rows containing dates greater than "today" 0

Back
Top