FieldName - Written In .txt file?

[Wayne & Carr]

Hello All

I have to [File | Get External Data | import] a lot of DATA into a Table.
What I would like to know is if there is a way to write in a text file .txt
The [FieldName] for each of the fields?

This way I do not have to edit all of the new FieldName's with the correct
information.

Any idea's on how this "could" be done?
Or is it impossible?

Thanks All;
Wayne

 

[Jeff Boyce]

Depending on whether the number/type of fields change or stay constant,
another approach would be to create your Access table(s) as needed for good
normalization, import your raw data to a temporary table, and use queries to
append and update data in the permanent tables from the temporary table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Depending on whether the number/type of fields change or stay constant,
another approach would be to create your Access table(s) as needed for good
normalization, import your raw data to a temporary table, and use queries to
append and update data in the permanent tables from the temporary table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Wayne & Carr]

Hello Jeff.

Could you perhaps provide a link to instructions on how to do this?
If it will make my life simplier, I am willing to try/do anything.

Thank you for your assistance.
Wayne

 

[Wayne & Carr]

Hello Jeff.

Could you perhaps provide a link to instructions on how to do this?
If it will make my life simplier, I am willing to try/do anything.

Thank you for your assistance.
Wayne

 

[Rick Wannall]

If you're importing a text files, comma delimited, the first row just has to
be this:

"column1", "column2", "column3", ...

Where column1 is the name of the first column etc. User your own column
names. Have you seen that referred to elsewhere but haven't been able to
get it to work for you?

 

[Rick Wannall]

If you're importing a text files, comma delimited, the first row just has to
be this:

"column1", "column2", "column3", ...

Where column1 is the name of the first column etc. User your own column
names. Have you seen that referred to elsewhere but haven't been able to
get it to work for you?

 

[Wayne & Carr]

Hello Rick;

When you enter in the FieldNames link you mentioned, is just
Added them in to the top Row, it does not rename the FieldName's F1 F2 F3
F4...

So doing it as you have mentioned is something that I have tried in the
past.
This is what it does.

F1 F2
Unique_ID Product Title exc...

Is there a way to replace the F1, F2 exc... FieldName's with your own?

Take Care
Wayne

 

[Wayne & Carr]

Hello Rick;

When you enter in the FieldNames link you mentioned, is just
Added them in to the top Row, it does not rename the FieldName's F1 F2 F3
F4...

So doing it as you have mentioned is something that I have tried in the
past.
This is what it does.

F1 F2
Unique_ID Product Title exc...

Is there a way to replace the F1, F2 exc... FieldName's with your own?

Take Care
Wayne

 

[Rick Wannall]

The place to put the list of field names ("column1", "column2" etc.) is in
the text file you're importing, before you import it.

One of the tabs in the import wizard gives you the option to specify that
the first row contains field names. If you put the list of field names in
the text field, before all data rows, you can say that you have field names
in the file and when you import the text file access will use the names you
supplied.

If someone else creates the text file, ask them if they can include the
field names in their process of creation. If they cannot, and if the names
are static (same for every text file) then you can prepare the header line
in your own text file somewhere, then copy and paste it into the data text
file, before you import that text file.

 

[Rick Wannall]

The place to put the list of field names ("column1", "column2" etc.) is in
the text file you're importing, before you import it.

One of the tabs in the import wizard gives you the option to specify that
the first row contains field names. If you put the list of field names in
the text field, before all data rows, you can say that you have field names
in the file and when you import the text file access will use the names you
supplied.

If someone else creates the text file, ask them if they can include the
field names in their process of creation. If they cannot, and if the names
are static (same for every text file) then you can prepare the header line
in your own text file somewhere, then copy and paste it into the data text
file, before you import that text file.

 

[Wayne & Carr]

Thanks Rick
I am doing some checking on the Import Wizard and the information that you
Provided, I have "Office 2000 Pro" so hopefully it will be available in that
version.

Wayne

 

[Wayne & Carr]

Thanks Rick
I am doing some checking on the Import Wizard and the information that you
Provided, I have "Office 2000 Pro" so hopefully it will be available in that
version.

Wayne

 

[Wayne & Carr]

I followed the information here
http://office.microsoft.com/en-us/assistance/HA010546511033.aspx
Of which I have been Importing this way all along.
BUT, It is not showing my the [Text Import Wizard]
And I cannot seen to find out "how" to make it appear?

So, going to do some more reading.

Wayne

 

[Wayne & Carr]

I followed the information here
http://office.microsoft.com/en-us/assistance/HA010546511033.aspx
Of which I have been Importing this way all along.
BUT, It is not showing my the [Text Import Wizard]
And I cannot seen to find out "how" to make it appear?

So, going to do some more reading.

Wayne

 

[Wayne & Carr]

The [Text Import Wizard] seems to be broken?
Cannot get it to show up.
I have re-registers [msexcl40.dll] but still nothing.

Any idea's on how to make the Wizard appear?
Is there an option, or do I have to install it?
From the CD?

 

[Wayne & Carr]

The [Text Import Wizard] seems to be broken?
Cannot get it to show up.
I have re-registers [msexcl40.dll] but still nothing.

Any idea's on how to make the Wizard appear?
Is there an option, or do I have to install it?
From the CD?

 

[Wayne & Carr]

I re-applied SP3 for Office 2000
Now I have my Wizard.

Thanks a Bunch Ricky
You are a life saver

Wayne

 

[Wayne & Carr]

I re-applied SP3 for Office 2000
Now I have my Wizard.

Thanks a Bunch Ricky
You are a life saver

Wayne

 

[Rick Wannall]

I'm only talking about using File, Get Data, Import. You can access the
same functions in vb code using docmd.transfertext.

How are you importing now, if you're not using either of these?

Ricky?