excel import problem

Hello, can anyone point me in the right direction for this problem,
much appreciated.
Basically importing date and time formatted data from a spreadsheet to
a table. It worked OK until the OS was changed from XP Home to XP pro
SP2, now get a runtime error. Can't find anything in Ms KB so any
suggestions appreciated.

re: excel import problem

oldeast wrote:[color=blue]
> Hello, can anyone point me in the right direction for this problem,
> much appreciated.
> Basically importing date and time formatted data from a spreadsheet[/color]
to[color=blue]
> a table. It worked OK until the OS was changed from XP Home to XP pro
> SP2, now get a runtime error. Can't find anything in Ms KB so any
> suggestions appreciated.[/color]

Checked out the references?

re: excel import problem

also check the security settings for macros in excel.

If you set them to low, it should work.
Tools | Macros | Security.


Tanis wrote:[color=blue]
> oldeast wrote:[color=green]
> > Hello, can anyone point me in the right direction for this problem,
> > much appreciated.
> > Basically importing date and time formatted data from a spreadsheet[/color]
> to[color=green]
> > a table. It worked OK until the OS was changed from XP Home to XP[/color][/color]
pro[color=blue][color=green]
> > SP2, now get a runtime error. Can't find anything in Ms KB so any
> > suggestions appreciated.[/color]
>
> Checked out the references?[/color]

re: excel import problem

misscrf wrote:[color=blue]
> also check the security settings for macros in excel.
>
> If you set them to low, it should work.
> Tools | Macros | Security.
>
>
> Tanis wrote:[color=green]
> > oldeast wrote:[color=darkred]
> > > Hello, can anyone point me in the right direction for this[/color][/color][/color]
problem,[color=blue][color=green][color=darkred]
> > > much appreciated.
> > > Basically importing date and time formatted data from a[/color][/color][/color]
spreadsheet[color=blue][color=green]
> > to[color=darkred]
> > > a table. It worked OK until the OS was changed from XP Home to XP[/color][/color]
> pro[color=green][color=darkred]
> > > SP2, now get a runtime error. Can't find anything in Ms KB so any
> > > suggestions appreciated.[/color]
> >
> > Checked out the references?[/color][/color]

re: excel import problem

Thanks for the advice, I also checked for more info, its runtime error
31519 apparently the input file is a ".dat" tab delimited file (but
viewed by excel),I have heard that changing the extension to .txt may
be a solution. Will report back results on security settings also.
misscrf wrote:[color=blue]
> also check the security settings for macros in excel.
>
> If you set them to low, it should work.
> Tools | Macros | Security.
>
>
> Tanis wrote:[color=green]
> > oldeast wrote:[color=darkred]
> > > Hello, can anyone point me in the right direction for this[/color][/color][/color]
problem,[color=blue][color=green][color=darkred]
> > > much appreciated.
> > > Basically importing date and time formatted data from a[/color][/color][/color]
spreadsheet[color=blue][color=green]
> > to[color=darkred]
> > > a table. It worked OK until the OS was changed from XP Home to XP[/color][/color]
> pro[color=green][color=darkred]
> > > SP2, now get a runtime error. Can't find anything in Ms KB so any
> > > suggestions appreciated.[/color]
> >
> > Checked out the references?[/color][/color]

re: excel import problem

Have changed the security settings and the same problem persists.
As for the .txt that seemed a silly idea anyway!
Many thanks for the feed bvack so far.

re: excel import problem

OK re the file extension change from.dat to .txt, it works if you open
the file with excel and do a save as to .txt.
thanks all

re: excel import problem

MSDN has an article that describes this 'feature'. This reference is to
AC2000 but it is applicable to everything since AC97.

http://support.microsoft.com/default...b;en-us;304206


Ron, King of Chi

oldeast wrote:[color=blue]
> OK re the file extension change from.dat to .txt, it works if you[/color]
open[color=blue]
> the file with excel and do a save as to .txt.
> thanks all[/color]