Hey everyone,

I'm being asked to export part of an Access database with number fields right justified padded w/ zeros and text fields left justified padded with spaces. This is going to a CSV file.

So long as the padding is on the correct side of the information, it doesn't matter how the data is justified when viewing it in Excel or Access correct?

For example, the date field has a length of 8 in YYYYMMDD format. If there are 8 digits it should be acceptable even if the number is showing up visually on the left side of the column in Access correct?