Ask a new question

Microsoft Access - How to change Data Type for multiple fields or columns

Dear friend,

I'm using Office 2019 ProPlus, there is Access 2016 along with it. When I'm trying to edit the table to change Data Type, I have to manually right click to design view then change the type one by one, is there any shortcut to do that if I wanted to change type for some certain columns?

I selected some but the property field was grayed out. any ideas?

No, you have to edit each individual field.

---
Best wishes, HansV
https://www.eileenslounge.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Hans,

Thanks for replying.

Further question is that, whenever I imported from excel, it comes with default short test type that I can't export as .dbf, so I have to manually change them to long text before exporting. Is there any way to make it default as long text, or how to identify which field or column that needs to be changed to long text before exporting? I can't imagine we have to do it manually if there were over 100+ columns.

Many thanks.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

When importing data from an external source, it usually better to link to the data THEN append the data to an existing table that has the data types set properly for your needs.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You might consider creating a new table with the proper data types using SQL: CREATE TABLE and INSERT statements are what to study, and then import the data into the properly typed table.

Author of The Ten Commandments Of VBA For Microsoft Access Newbies

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 7, 2022 Views 2,217 Applies to: