Export Table with Specifications (1 Viewer)

DBFIN

Registered User.
Local time
Today, 08:20
Joined
May 10, 2007
Messages
205
I created a table with an older version of MS Access which was replaced with Access 2010. I was able to export the table simply by selecting specifications that I created.

How do I export with these same specifications in Access 2010 ?
 

Ranman256

Well-known member
Local time
Today, 08:20
Joined
Apr 9, 2015
Messages
4,339
in a macro
ImportExportText
spec
table, etc
 

DBFIN

Registered User.
Local time
Today, 08:20
Joined
May 10, 2007
Messages
205
I just ran the macro and discovered the specifications were corrupted. How do I recreate the specifications ?
 

DBFIN

Registered User.
Local time
Today, 08:20
Joined
May 10, 2007
Messages
205
I need to create specifications with delimiters that define field lenghts for each field.
 

DBFIN

Registered User.
Local time
Today, 08:20
Joined
May 10, 2007
Messages
205
I figured it out, must leave box unchecked when selecting External Data, Text File.
 

Users who are viewing this thread

Top Bottom