I tried importing the SAP dump as a .txt, and as an .xls. I cleaned up the
file so it is strictly tabular format with the same type of content in every
column (field), just like an Access table. I reduced the number of lines from
5,000+ to only 250 to try to troubleshoot. Every time, Access crashes. Am I
missing an Add-in?
--
andrea c moore

acmoore,

Are you using the File-Import or an Import Specification? What version of
Access and what version of Excel?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"acmoore" <(E-Mail Removed)> wrote in message
news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
>I tried importing the SAP dump as a .txt, and as an .xls. I cleaned up the
> file so it is strictly tabular format with the same type of content in
> every
> column (field), just like an Access table. I reduced the number of lines
> from
> 5,000+ to only 250 to try to troubleshoot. Every time, Access crashes. Am
> I
> missing an Add-in?
> --
> andrea c moore

Gina,

Thanks so much for responding. I am using Excel 2003, Access 2003 (Access
2000 file format). So far I have been trying to do this using File>Get
External Data>Import and trying Table>New>Import Table.

I used to do a job like this daily about 5 years ago - and I kind of recall
using an import specification. That may do the trick.

Even so, I still don't understand why Access crashes when I try to import
the Excel data that is in perfectly tabular format.
--
andrea c moore


"Gina Whipp" wrote:

> acmoore,
>
> Are you using the File-Import or an Import Specification? What version of
> Access and what version of Excel?
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "acmoore" <(E-Mail Removed)> wrote in message
> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
> >I tried importing the SAP dump as a .txt, and as an .xls. I cleaned up the
> > file so it is strictly tabular format with the same type of content in
> > every
> > column (field), just like an Access table. I reduced the number of lines
> > from
> > 5,000+ to only 250 to try to troubleshoot. Every time, Access crashes. Am
> > I
> > missing an Add-in?
> > --
> > andrea c moore
>
>
> .
>

acmoore,

Well, nothing wrong with version or what your doing so... Do the column
headers use any Reserved Words or contain any symbols? Does the data
contain any symbols?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"acmoore" <(E-Mail Removed)> wrote in message
news6C518BA-118A-4B58-9106-(E-Mail Removed)...
> Gina,
>
> Thanks so much for responding. I am using Excel 2003, Access 2003 (Access
> 2000 file format). So far I have been trying to do this using File>Get
> External Data>Import and trying Table>New>Import Table.
>
> I used to do a job like this daily about 5 years ago - and I kind of
> recall
> using an import specification. That may do the trick.
>
> Even so, I still don't understand why Access crashes when I try to import
> the Excel data that is in perfectly tabular format.
> --
> andrea c moore
>
>
> "Gina Whipp" wrote:
>
>> acmoore,
>>
>> Are you using the File-Import or an Import Specification? What version
>> of
>> Access and what version of Excel?
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "acmoore" <(E-Mail Removed)> wrote in message
>> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
>> >I tried importing the SAP dump as a .txt, and as an .xls. I cleaned up
>> >the
>> > file so it is strictly tabular format with the same type of content in
>> > every
>> > column (field), just like an Access table. I reduced the number of
>> > lines
>> > from
>> > 5,000+ to only 250 to try to troubleshoot. Every time, Access crashes.
>> > Am
>> > I
>> > missing an Add-in?
>> > --
>> > andrea c moore
>>
>>
>> .
>>

Gina,

I've vetted that as well. I imported the Excel file Access 97 just to check
that. The import wizard identified two field labels with problems, but still
imported the file successfully by renaming the fields. After that import
completed, I shut down Access 97, opened the Excel file, fixed the cells,
saved, and tried Access 2003 again. Still no luck. Access crashed for the
27th time. That's funny because today is the 27th and it's my birthday.

In Help, I found a link for troubleshooting importing data. The lead I am
trying to work is the "wizard disappears". I'm doing a search right now for
the dll. However, the problem and hotfix appear to only apply to Access 2002.

I don't see any other links that indicate the specific problem I have -
Access shutting down (backing up, and sending error report).

I also searched Help for import specification. That turned up pretty dry. A
bunch of references to the same importation instructions that are not working
for me. Can you point me to any reference material?

Is this issue maybe because I have Access 97 still installed? I didn't
realize I still had it until I looked through my program menu in desperation.

Thanks for helping me with this - trying to apply my CPE course training for
work as I go.
--
andrea c moore


"Gina Whipp" wrote:

> acmoore,
>
> Well, nothing wrong with version or what your doing so... Do the column
> headers use any Reserved Words or contain any symbols? Does the data
> contain any symbols?
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "acmoore" <(E-Mail Removed)> wrote in message
> news6C518BA-118A-4B58-9106-(E-Mail Removed)...
> > Gina,
> >
> > Thanks so much for responding. I am using Excel 2003, Access 2003 (Access
> > 2000 file format). So far I have been trying to do this using File>Get
> > External Data>Import and trying Table>New>Import Table.
> >
> > I used to do a job like this daily about 5 years ago - and I kind of
> > recall
> > using an import specification. That may do the trick.
> >
> > Even so, I still don't understand why Access crashes when I try to import
> > the Excel data that is in perfectly tabular format.
> > --
> > andrea c moore
> >
> >
> > "Gina Whipp" wrote:
> >
> >> acmoore,
> >>
> >> Are you using the File-Import or an Import Specification? What version
> >> of
> >> Access and what version of Excel?
> >>
> >> --
> >> Gina Whipp
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >> http://www.regina-whipp.com/index_files/TipList.htm
> >>
> >> "acmoore" <(E-Mail Removed)> wrote in message
> >> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
> >> >I tried importing the SAP dump as a .txt, and as an .xls. I cleaned up
> >> >the
> >> > file so it is strictly tabular format with the same type of content in
> >> > every
> >> > column (field), just like an Access table. I reduced the number of
> >> > lines
> >> > from
> >> > 5,000+ to only 250 to try to troubleshoot. Every time, Access crashes.
> >> > Am
> >> > I
> >> > missing an Add-in?
> >> > --
> >> > andrea c moore
> >>
> >>
> >> .
> >>
>
>
> .
>

andrea,

First, HAPPY BIRTHDAY!

Now on to business... Earlier versions of Access were MUCH more tolerant of
using Reserved Words as fields names. Access 2007 has zero toloerance. You
can check here for Reserved Words and see if any match your field names...
http://allenbrowne.com/Ap****ueBadWord.html

Also, certain characters will cause issues, such as comma, pound sign,
forward slash, etc... which is why I asked if your file contained any of
these characters. Doesn't sound like a Wizard issue because it's not gone,
the file just file to import.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"acmoore" <(E-Mail Removed)> wrote in message
news:3FBE267E-61A2-4AEC-9606-(E-Mail Removed)...
> Gina,
>
> I've vetted that as well. I imported the Excel file Access 97 just to
> check
> that. The import wizard identified two field labels with problems, but
> still
> imported the file successfully by renaming the fields. After that import
> completed, I shut down Access 97, opened the Excel file, fixed the cells,
> saved, and tried Access 2003 again. Still no luck. Access crashed for the
> 27th time. That's funny because today is the 27th and it's my birthday.
>
> In Help, I found a link for troubleshooting importing data. The lead I am
> trying to work is the "wizard disappears". I'm doing a search right now
> for
> the dll. However, the problem and hotfix appear to only apply to Access
> 2002.
>
> I don't see any other links that indicate the specific problem I have -
> Access shutting down (backing up, and sending error report).
>
> I also searched Help for import specification. That turned up pretty dry.
> A
> bunch of references to the same importation instructions that are not
> working
> for me. Can you point me to any reference material?
>
> Is this issue maybe because I have Access 97 still installed? I didn't
> realize I still had it until I looked through my program menu in
> desperation.
>
> Thanks for helping me with this - trying to apply my CPE course training
> for
> work as I go.
> --
> andrea c moore
>
>
> "Gina Whipp" wrote:
>
>> acmoore,
>>
>> Well, nothing wrong with version or what your doing so... Do the column
>> headers use any Reserved Words or contain any symbols? Does the data
>> contain any symbols?
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "acmoore" <(E-Mail Removed)> wrote in message
>> news6C518BA-118A-4B58-9106-(E-Mail Removed)...
>> > Gina,
>> >
>> > Thanks so much for responding. I am using Excel 2003, Access 2003
>> > (Access
>> > 2000 file format). So far I have been trying to do this using File>Get
>> > External Data>Import and trying Table>New>Import Table.
>> >
>> > I used to do a job like this daily about 5 years ago - and I kind of
>> > recall
>> > using an import specification. That may do the trick.
>> >
>> > Even so, I still don't understand why Access crashes when I try to
>> > import
>> > the Excel data that is in perfectly tabular format.
>> > --
>> > andrea c moore
>> >
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> acmoore,
>> >>
>> >> Are you using the File-Import or an Import Specification? What
>> >> version
>> >> of
>> >> Access and what version of Excel?
>> >>
>> >> --
>> >> Gina Whipp
>> >>
>> >> "I feel I have been denied critical, need to know, information!" -
>> >> Tremors
>> >> II
>> >>
>> >> http://www.regina-whipp.com/index_files/TipList.htm
>> >>
>> >> "acmoore" <(E-Mail Removed)> wrote in message
>> >> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
>> >> >I tried importing the SAP dump as a .txt, and as an .xls. I cleaned
>> >> >up
>> >> >the
>> >> > file so it is strictly tabular format with the same type of content
>> >> > in
>> >> > every
>> >> > column (field), just like an Access table. I reduced the number of
>> >> > lines
>> >> > from
>> >> > 5,000+ to only 250 to try to troubleshoot. Every time, Access
>> >> > crashes.
>> >> > Am
>> >> > I
>> >> > missing an Add-in?
>> >> > --
>> >> > andrea c moore
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

Thanks Gina. I tried uninstalling Access 97 and that did the trick. I can
import fine now.
--
andrea c moore


"Gina Whipp" wrote:

> andrea,
>
> First, HAPPY BIRTHDAY!
>
> Now on to business... Earlier versions of Access were MUCH more tolerant of
> using Reserved Words as fields names. Access 2007 has zero toloerance. You
> can check here for Reserved Words and see if any match your field names...
> http://allenbrowne.com/Ap****ueBadWord.html
>
> Also, certain characters will cause issues, such as comma, pound sign,
> forward slash, etc... which is why I asked if your file contained any of
> these characters. Doesn't sound like a Wizard issue because it's not gone,
> the file just file to import.
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "acmoore" <(E-Mail Removed)> wrote in message
> news:3FBE267E-61A2-4AEC-9606-(E-Mail Removed)...
> > Gina,
> >
> > I've vetted that as well. I imported the Excel file Access 97 just to
> > check
> > that. The import wizard identified two field labels with problems, but
> > still
> > imported the file successfully by renaming the fields. After that import
> > completed, I shut down Access 97, opened the Excel file, fixed the cells,
> > saved, and tried Access 2003 again. Still no luck. Access crashed for the
> > 27th time. That's funny because today is the 27th and it's my birthday.
> >
> > In Help, I found a link for troubleshooting importing data. The lead I am
> > trying to work is the "wizard disappears". I'm doing a search right now
> > for
> > the dll. However, the problem and hotfix appear to only apply to Access
> > 2002.
> >
> > I don't see any other links that indicate the specific problem I have -
> > Access shutting down (backing up, and sending error report).
> >
> > I also searched Help for import specification. That turned up pretty dry.
> > A
> > bunch of references to the same importation instructions that are not
> > working
> > for me. Can you point me to any reference material?
> >
> > Is this issue maybe because I have Access 97 still installed? I didn't
> > realize I still had it until I looked through my program menu in
> > desperation.
> >
> > Thanks for helping me with this - trying to apply my CPE course training
> > for
> > work as I go.
> > --
> > andrea c moore
> >
> >
> > "Gina Whipp" wrote:
> >
> >> acmoore,
> >>
> >> Well, nothing wrong with version or what your doing so... Do the column
> >> headers use any Reserved Words or contain any symbols? Does the data
> >> contain any symbols?
> >>
> >> --
> >> Gina Whipp
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >> http://www.regina-whipp.com/index_files/TipList.htm
> >>
> >> "acmoore" <(E-Mail Removed)> wrote in message
> >> news6C518BA-118A-4B58-9106-(E-Mail Removed)...
> >> > Gina,
> >> >
> >> > Thanks so much for responding. I am using Excel 2003, Access 2003
> >> > (Access
> >> > 2000 file format). So far I have been trying to do this using File>Get
> >> > External Data>Import and trying Table>New>Import Table.
> >> >
> >> > I used to do a job like this daily about 5 years ago - and I kind of
> >> > recall
> >> > using an import specification. That may do the trick.
> >> >
> >> > Even so, I still don't understand why Access crashes when I try to
> >> > import
> >> > the Excel data that is in perfectly tabular format.
> >> > --
> >> > andrea c moore
> >> >
> >> >
> >> > "Gina Whipp" wrote:
> >> >
> >> >> acmoore,
> >> >>
> >> >> Are you using the File-Import or an Import Specification? What
> >> >> version
> >> >> of
> >> >> Access and what version of Excel?
> >> >>
> >> >> --
> >> >> Gina Whipp
> >> >>
> >> >> "I feel I have been denied critical, need to know, information!" -
> >> >> Tremors
> >> >> II
> >> >>
> >> >> http://www.regina-whipp.com/index_files/TipList.htm
> >> >>
> >> >> "acmoore" <(E-Mail Removed)> wrote in message
> >> >> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
> >> >> >I tried importing the SAP dump as a .txt, and as an .xls. I cleaned
> >> >> >up
> >> >> >the
> >> >> > file so it is strictly tabular format with the same type of content
> >> >> > in
> >> >> > every
> >> >> > column (field), just like an Access table. I reduced the number of
> >> >> > lines
> >> >> > from
> >> >> > 5,000+ to only 250 to try to troubleshoot. Every time, Access
> >> >> > crashes.
> >> >> > Am
> >> >> > I
> >> >> > missing an Add-in?
> >> >> > --
> >> >> > andrea c moore
> >> >>
> >> >>
> >> >> .
> >> >>
> >>
> >>
> >> .
> >>
>
>
> .
>

Andrea,

Glad that worked but odd because I have Access 97 to 2007 with no issues...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"acmoore" <(E-Mail Removed)> wrote in message
news:FE510A4B-BAE1-48BC-BCFB-(E-Mail Removed)...
> Thanks Gina. I tried uninstalling Access 97 and that did the trick. I can
> import fine now.
> --
> andrea c moore
>
>
> "Gina Whipp" wrote:
>
>> andrea,
>>
>> First, HAPPY BIRTHDAY!
>>
>> Now on to business... Earlier versions of Access were MUCH more tolerant
>> of
>> using Reserved Words as fields names. Access 2007 has zero toloerance.
>> You
>> can check here for Reserved Words and see if any match your field
>> names...
>> http://allenbrowne.com/Ap****ueBadWord.html
>>
>> Also, certain characters will cause issues, such as comma, pound sign,
>> forward slash, etc... which is why I asked if your file contained any of
>> these characters. Doesn't sound like a Wizard issue because it's not
>> gone,
>> the file just file to import.
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "acmoore" <(E-Mail Removed)> wrote in message
>> news:3FBE267E-61A2-4AEC-9606-(E-Mail Removed)...
>> > Gina,
>> >
>> > I've vetted that as well. I imported the Excel file Access 97 just to
>> > check
>> > that. The import wizard identified two field labels with problems, but
>> > still
>> > imported the file successfully by renaming the fields. After that
>> > import
>> > completed, I shut down Access 97, opened the Excel file, fixed the
>> > cells,
>> > saved, and tried Access 2003 again. Still no luck. Access crashed for
>> > the
>> > 27th time. That's funny because today is the 27th and it's my birthday.
>> >
>> > In Help, I found a link for troubleshooting importing data. The lead I
>> > am
>> > trying to work is the "wizard disappears". I'm doing a search right now
>> > for
>> > the dll. However, the problem and hotfix appear to only apply to Access
>> > 2002.
>> >
>> > I don't see any other links that indicate the specific problem I have -
>> > Access shutting down (backing up, and sending error report).
>> >
>> > I also searched Help for import specification. That turned up pretty
>> > dry.
>> > A
>> > bunch of references to the same importation instructions that are not
>> > working
>> > for me. Can you point me to any reference material?
>> >
>> > Is this issue maybe because I have Access 97 still installed? I didn't
>> > realize I still had it until I looked through my program menu in
>> > desperation.
>> >
>> > Thanks for helping me with this - trying to apply my CPE course
>> > training
>> > for
>> > work as I go.
>> > --
>> > andrea c moore
>> >
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> acmoore,
>> >>
>> >> Well, nothing wrong with version or what your doing so... Do the
>> >> column
>> >> headers use any Reserved Words or contain any symbols? Does the data
>> >> contain any symbols?
>> >>
>> >> --
>> >> Gina Whipp
>> >>
>> >> "I feel I have been denied critical, need to know, information!" -
>> >> Tremors
>> >> II
>> >>
>> >> http://www.regina-whipp.com/index_files/TipList.htm
>> >>
>> >> "acmoore" <(E-Mail Removed)> wrote in message
>> >> news6C518BA-118A-4B58-9106-(E-Mail Removed)...
>> >> > Gina,
>> >> >
>> >> > Thanks so much for responding. I am using Excel 2003, Access 2003
>> >> > (Access
>> >> > 2000 file format). So far I have been trying to do this using
>> >> > File>Get
>> >> > External Data>Import and trying Table>New>Import Table.
>> >> >
>> >> > I used to do a job like this daily about 5 years ago - and I kind of
>> >> > recall
>> >> > using an import specification. That may do the trick.
>> >> >
>> >> > Even so, I still don't understand why Access crashes when I try to
>> >> > import
>> >> > the Excel data that is in perfectly tabular format.
>> >> > --
>> >> > andrea c moore
>> >> >
>> >> >
>> >> > "Gina Whipp" wrote:
>> >> >
>> >> >> acmoore,
>> >> >>
>> >> >> Are you using the File-Import or an Import Specification? What
>> >> >> version
>> >> >> of
>> >> >> Access and what version of Excel?
>> >> >>
>> >> >> --
>> >> >> Gina Whipp
>> >> >>
>> >> >> "I feel I have been denied critical, need to know, information!" -
>> >> >> Tremors
>> >> >> II
>> >> >>
>> >> >> http://www.regina-whipp.com/index_files/TipList.htm
>> >> >>
>> >> >> "acmoore" <(E-Mail Removed)> wrote in message
>> >> >> news:1C8899A4-DCE1-41AB-8D89-(E-Mail Removed)...
>> >> >> >I tried importing the SAP dump as a .txt, and as an .xls. I
>> >> >> >cleaned
>> >> >> >up
>> >> >> >the
>> >> >> > file so it is strictly tabular format with the same type of
>> >> >> > content
>> >> >> > in
>> >> >> > every
>> >> >> > column (field), just like an Access table. I reduced the number
>> >> >> > of
>> >> >> > lines
>> >> >> > from
>> >> >> > 5,000+ to only 250 to try to troubleshoot. Every time, Access
>> >> >> > crashes.
>> >> >> > Am
>> >> >> > I
>> >> >> > missing an Add-in?
>> >> >> > --
>> >> >> > andrea c moore
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>