Want this question answered?
yes, it can
It will put the fields in Access into columns in Excel, and records in Access will be in rows in Excel. Data will be converted to appropriate data types.
The purpose is the preamble signals to the receiving node that data is incoming and indicates when the data flow is about to begin. The SFD (start-of-frame delimiter) identifies where the data field begans.
A delimiter is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams. An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values
1) Copy the data to be converted 2) Paste Specialand tick the Transpose box
Data organized into columns and rows is called a table.
In columns and rows. The columns generally have titles
Use the Text To Columns option in the Data menu. If you have some data in a column that is comma separated you can select it and with the Text To Columns option you can spread it out to the neighbouring columns, breaking the data at the commas.
You can enter data in any columns you like.
Fields
table
no