I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

That was the answer I thought I would get. Can I create a template to use
when I import from the database?

"Peo Sjoblom" wrote:

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

If you can save the data as a .txt file, you could start a new workbook, then
record a macro when you open the .txt file.

Record your actions as you import each field (choosing the correct date format).

In fact, continue recording when you're adding headers/filters/page setup/etc.

Then save that workbook with the recorded code. Next time you need to import a
similar text file, just open the macro workbook and tools|macro|macros... and
run that macro.



Chris Davidson NGSS wrote:

That was the answer I thought I would get. Can I create a template to use
when I import from the database?

"Peo Sjoblom" wrote:

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

--

Dave Peterson

OK That will not do. The data comes as an Excel Spreadsheet. So can Excel
ne made to open with a template? If I can do that then the problem is solved
and the game is over. I have tried placing the template in the C:\Program
Files\Microsoft Office\Office11\XLSart and the template is named Sheet.xlt.
When I open up Excel it opens like there is no template. What am I doing
wrong?

Thanks so far with the help.

"Dave Peterson" wrote:

If you can save the data as a .txt file, you could start a new workbook, then
record a macro when you open the .txt file.

Record your actions as you import each field (choosing the correct date format).

In fact, continue recording when you're adding headers/filters/page setup/etc.

Then save that workbook with the recorded code. Next time you need to import a
similar text file, just open the macro workbook and tools|macro|macros... and
run that macro.



Chris Davidson NGSS wrote:

That was the answer I thought I would get. Can I create a template to use
when I import from the database?

"Peo Sjoblom" wrote:

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

--

Dave Peterson

If you mean you get the data as a workbook, then the dates have been converted
already and it's too late.

I'm not sure how a template would work to resolve this.

Chris Davidson NGSS wrote:

OK That will not do. The data comes as an Excel Spreadsheet. So can Excel
ne made to open with a template? If I can do that then the problem is solved
and the game is over. I have tried placing the template in the C:\Program
Files\Microsoft Office\Office11\XLSart and the template is named Sheet.xlt.
When I open up Excel it opens like there is no template. What am I doing
wrong?

Thanks so far with the help.

"Dave Peterson" wrote:

If you can save the data as a .txt file, you could start a new workbook, then
record a macro when you open the .txt file.

Record your actions as you import each field (choosing the correct date format).

In fact, continue recording when you're adding headers/filters/page setup/etc.

Then save that workbook with the recorded code. Next time you need to import a
similar text file, just open the macro workbook and tools|macro|macros... and
run that macro.



Chris Davidson NGSS wrote:

That was the answer I thought I would get. Can I create a template to use
when I import from the database?

"Peo Sjoblom" wrote:

Unfortunately no, unless you can import the date fields as text

Regards,

Peo Sjoblom

"Chris Davidson NGSS" wrote:

I have a Oracle database I am importing from and placing the data in Excel.
When Excel imports the data in, some of data is re-formatted. For example, I
have data that is like 04-01-01 and it converts it to 4/01/2001. Is there a
way to turn the auto formatting feature off so I can import the data as is?
I have looked everywhere and I can not find out how to shut it off.

Thanks in advance.

--

Dave Peterson


--

Dave Peterson