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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 Export to Excel

Status
Not open for further replies.
wfweirich

wfweirich

Programmer
Sep 10, 2001
21
US
I have a critical application here at work that was created using Access 97. This is a shared system which is why we are unable, at this time, to convert to Access 2000 or SQL Server with an Access front-end. At times we are asked to export raw data into Excel. Unfortunately, our tables comtain memo fields that do not show up in their entirety in Excel. They export just fine, but some of the data is truncated. Is there a way to change defaults or properties of fields in Excel in order to collect all of the data. Any suggested or proven solution would be greatly appreciated.
Thanks. wfw
 
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
345
dhookom
dhookom
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
1K
strongm
strongm
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
551
mikrom
mikrom
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
4K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top