import/export specification

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

How can I add a column and re-order the column in an existing import/export
specification with access97? Thanks.
 
You can try create a query with SQL view of
SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;

You may have success modifying the records in the query but you must be very
cautious.
 
Thanks for the information. This seems a bit complicated because I need to
re-adjust the startid and width for every column. Is there an easy way.
 
You could go through the wizard again and edit the specs or just do it in
the query.
 
I tried to go to the wizard again but somehow I cannot add an extra field
and put it in the right order in the spec. Do you have any guideline?
Thanks.
 
Build a query with the correct fields you want in the correct order in the
grid.

Then invoke the export wizard on that query...you find this much easier....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to Export Gmail Emails to PST Format? 4
Easy Steps to Import PST Files to Office 365 0
How to Convert EML to PST? 2
How can I migrate MBOX to PST? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
TransferSpreadsheet question 2
Exporting CSV File in format "FilenameYYYYMMDD" 7

Back
Top