Include field names on first row - With Export Specifications

[FixItPete]

I do an export to text file I am allowed to include the field names on first row. Save it, and it works.

BUT...

How can I make it so that an Export Specification does this too. I can get the Export Specification to do everything, but it will *not* include the field names on the first row.

Thanks,

Pete

 

[FixItPete]

Still working on it... and still nothing.

 

[FixItPete]

Hmmm... I starting to wonder if this is something that Access simply can't do?

Please help,

Pete

 

[Pat Hartman]

Are you checking the correct box when you run through the export wizard to create the export spec?

 

[FixItPete]

Hi Pat!

(Really happy to see your reply!)

I think I am.

Here is *exactly* what I do.

1) got to my query (made from my table)
2) I go to File>Export
3) @ "Save as type" I select "Text File"
4) I click "Save All" (Both boxes to left of "Save All" button are left unchecked)
5) I click "Delimted"
6) I click "Next"
7) I select "Other" and make it pipe delimited (|)
8) I make Text Qualifer "none"
9) I click "Include Field Names On First Row"
10) I click "Next"

***NOW***

How do I get THAT to work with a "Saved" Specification? (The "thing" you create when you use the "Advanced..." button? In other words, I can replicate all of that EXCEPT the "Include field names on first row". You see, I'm running a Macro that I need to take the query and and export it as a flat file, pipe delimted, WITH the field names as the first row. It is the field names in the first row that I need to "automate" some how.

Thanks for reading,

Pete

 

[Pat Hartman]

Once the spec has been "created", you need to save it. Click the advanced tab to get to the save option. I NEVER use macros so it may be the macro that is causing the problem. Convert the macro to VBA, you can use the menu option to help you.

 

[FixItPete]

Hi,

OK!

"Has Field Names" is a dropdown on the macro create...

All fixed!!

Pete

 

[creek]

Hi,

OK!

"Has Field Names" is a dropdown on the macro create...

All fixed!!

Pete

Ok i have the exact same situation, I want to exclude Column Names, and use a macro to generate (.csv) files. I can't get to change the specification to import just the data.

I did'nt understand the part about changing the macro to VBA what does that mean ? anyone please asap

 

[Pat Hartman]

There's a checkbox somewhere that says to include field names. Uncheck it.

Macros cannot be modified at runtime. They always write the same filename to the same place. If you need this to be variable, you need to use VBA rather than a macro.

 

[Wminnette]

Tools/Macros/Convert Macros to Visual Basic.