• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Importing and Exporting Data > Exporting Data from Access to Anothe...

Exporting Data from Access to Another Database

Access gives you lots of ways to import data from other sources, but data exchange works both ways. You can use data from databases like Paradox and dBASE and spreadsheets like Excel and Lotus 1-2-3, and you can export your data to those formats as well.

You can export your Access data as a delimited or a fixed width text file. Delimited text files are files where values in fields are separated by a particular character, like a comma or semicolon (Figure 12.27). Fixed width text files don't separate field values with special characters. Instead, they allot a specific number of characters to each field and wherever necessary, add extra spaces to the value to make the character count come out right (Figure 12.28). In a fixed width table with three fields of 30, 20, and 20 spaces each, the value in the first field always starts in the first space, the second field's value always starts in the 31st space, and the final field's value always starts in the 51st space (the first space following the first and second fields).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint