Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting Data Transferred from Access to Excel
- Thread starter raymone
- Start date
you can't, access only has the set transfertext functions, so if it's not formatted like that, then you're in trouble...
what you can do is to pull in the data from the excel spreadsheet...
use a recordset, pull in the data, then step through the recordset and assign/format the values however you want
--------------------
Procrastinate Now!
what you can do is to pull in the data from the excel spreadsheet...
use a recordset, pull in the data, then step through the recordset and assign/format the values however you want
--------------------
Procrastinate Now!
- Status
Similar threads
- Locked
- Question
- Locked
- Question