TonyLackey
Registered User.
- Local time
- Today, 03:24
- Joined
- Oct 9, 2002
- Messages
- 19
Hello again....
I'm trying to export data to excel and at the same time restrict the field sizes to match my table info. Is there an easy way to accomplish this without using code?
Example:-
My Query is exporting the following Fields
CompTypeNo, Text, 30
CompName, Text, 40
LastReported, Date/Time
I am creating excel spreadsheets for data collection purposes. I can restrict manually in Excel, but it takes ages. Some of the data already exists, hence the query! They either append to the data or modify what is already there.
Any help is appreciated.
T
I'm trying to export data to excel and at the same time restrict the field sizes to match my table info. Is there an easy way to accomplish this without using code?
Example:-
My Query is exporting the following Fields
CompTypeNo, Text, 30
CompName, Text, 40
LastReported, Date/Time
I am creating excel spreadsheets for data collection purposes. I can restrict manually in Excel, but it takes ages. Some of the data already exists, hence the query! They either append to the data or modify what is already there.
Any help is appreciated.
T
