By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,292 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,292 IT Pros & Developers. It's quick & easy.

excel import problem

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a

oldeast wrote:
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.


Checked out the references?

Nov 13 '05 #2

P: n/a
also check the security settings for macros in excel.

If you set them to low, it should work.
Tools | Macros | Security.
Tanis wrote:
oldeast wrote:
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.


Checked out the references?


Nov 13 '05 #3

P: n/a

misscrf wrote:
also check the security settings for macros in excel.

If you set them to low, it should work.
Tools | Macros | Security.
Tanis wrote:
oldeast wrote:
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.


Checked out the references?


Nov 13 '05 #4

P: n/a
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:
also check the security settings for macros in excel.

If you set them to low, it should work.
Tools | Macros | Security.
Tanis wrote:
oldeast wrote:
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.


Checked out the references?


Nov 13 '05 #5

P: n/a
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.

Nov 13 '05 #6

P: n/a
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

Nov 13 '05 #7

P: n/a
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:
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


Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.