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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access export

Status
Not open for further replies.
busalesl

busalesl

MIS
May 19, 2003
3
GB
I want to export 1 field from an access table into a text file. I can do this no problem into a file where each record is on a separate line, but the format that I want is "record1,record2,record3" etc.

I'm struggling, any ideas would be appreciated [afro]
 
Sort by date Sort by votes
Hi,

You open the text file in Excel using the Text Import Wizard.

Depending on the number of rows (if it's greater than 255, this will not work)...

copy the list

select a blank sheet A1

paste special - transpose

save as delimited text

VOLA :)


Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Question
Please help with my access report
Replies
7
Views
667
dhookom
dhookom
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
573
combo
combo
TrekBiker
  • Locked
  • Question
Using Access Remotely
Replies
2
Views
280
dhookom
dhookom
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
303
techie131
techie131
ladyck3
  • Locked
  • Question
Checkbook CSV export to XLSX (Office 365): Convert date format to a simple date
Replies
5
Views
279
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top