Export of Access Table (Finding Export Wizard)

Export of Access Table (Finding Export Wizard)

Post by UnVzdHkgRH » Fri, 05 May 2006 00:22:02


As an 'ex-user' of Access 2000, everytime i exported an access table to a
'txt' format, i was given the export wizard to specify how i wanted the data
presented.

Now that i have upgraded to 2003, everytime i export a table, there is no
wizard; the file is simply exported. Because i cannot specify how i want the
data presented, i cannot create the 'txt' needed in the correct format.

Is there an export wizard in 2003 to create the 'txt' file from the access
table so i can specify how i want the data presented?
 
 
 

1. sql2005 Import/Export wizard VS sql2000 Import/Export wizard

2. sql2005 Import/Export wizard VS sql2000 Import/Export wizard - p

I created a tab delimited textfile in a vb.net app. I was then able to read
the contents of this textfile from the vb.net app and write the contents to a
sql2000 DB. I was also able to import the contents of this textfile to the
same sql2000 DB using the sql2000 Import wizard. However, when I used the
sql2005 Import wizard for this same textfile I got an error message that it
had some kind of problem with the textfile and was truncating something.
But the sql2005 import wizard did work on other textfiles I created with the
same vb.net app.

The issue is that someone is going to be this one particular textfile which
gets its data from a sql2000 DB. This person has a sql2005 management
console and is not a programmer/developer/administrator...

Are there any known issues with the sql2005 import/export wizard? Or is
there something I could do to the textfile so that the sql2005 Import wizard
does not complain? Maybe a custom delimiter?

I also observed that the sql2000 Import wizard has an option (other) for a
custom column delimiter but I don't see this option in the sql2005 Import
wizard. Is there a way to get a custom column delimeter for the sql2005
Import wizard to use?

Any advice appreciated.

Thanks,
Rich

3. Exporting to Excel: Multiple tables in 1 spreadsheet - the last of 3 tables won't export.

4. Import/Export Wizard only allows importing and exporting of fa

5. Export Database using DTS Import/Export Wizard

6. Import/Export Wizard only allows importing and exporting of favori

7. SQL Server Import and Export Wizard - export slow after upg to SQL

8. Can not complete the export wizard when exporting contacts to exce

9. Can not complete the export wizard when exporting contacts to

10. Can't export some files to dreamweaver from export wizard..why?

11. Export Error Table created After Exportin A Table From Access To Excel?

12. Export access table to Sharepoint as an Excell table

13. export an access table into a word document as a word table

14. I can't find the sql server 2005 Imports and export wizard

15. Table Header not being printed/exported when exporting as CSV