importing/exporting from access to excel
Hi all,
I need a CVS file with some data I have in an access query. To do that I'm trying to import (in excel) and Export (in access), and everything goes right except the fields where I have up to 255 characters. These (in excel) only shows the first 255 characters. How to resolve this problem? or better, How to create a CSV file from my Access query? Thank you all. Tom. |
In Access, rtclick the Query Icon, choose Export from the shortcut menu, &
change the File Type at bottom of the dialog box to whatever you need. If "Text File", the next dialog box provides options for format which vary depending on whether you check the box for "Save Formatted". HTH |:) "Thomas" wrote: Hi all, I need a CVS file with some data I have in an access query. To do that I'm trying to import (in excel) and Export (in access), and everything goes right except the fields where I have up to 255 characters. These (in excel) only shows the first 255 characters. How to resolve this problem? or better, How to create a CSV file from my Access query? Thank you all. Tom. |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com