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

export data to .txt and lost digits

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I guess this is a simple question but I just can't do it.

my data is in mdb format:
lat. long.
27.123456 -82.2154021

After exported to txt format:
lat. long.
27.12 -82.22

I've tried setup the format from "auto" to "5" in design view, but didn't work. I need a ASCII type file to do some other conversion on lat/long. That's why I do this. Is there any way to export it and keep all the digits?

Thanks.
 
Simple copy and paste from Access to Excel, Word, etc. work well. You might need |Paste |Special |plain text if needed to avoid problems with boxes. or paste to Wordpad as plain text, then copy and paste elsewhere.

Else, export first as Excel file, then import into elsewhere.

Lotus 123, Quattro Pro should be similar.

Dave Y
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top