Importing Hangups

[Guest]

Afternoon,

I'm trying to have a linked excel spreadsheet update in access and in doing
so, the system just hangs or freezes.
I have updated the link in tools,database utilities, file manager and I have
steped into the VBA to change the link as well, still I hangs/freezes up,
any help would be greatly appreciated.

Thanks

 

[John Nurick]

Hi Norm,

What do you mean by "update"?

Do you get the same problem with all Excel spreadsheets or just this
particular one? Does it make a difference whereabouts on your network
the file is?

 

[Guest]

What I meant to say was thatit is linked and when press the cmd button to to
retrive it and update in access with the new data from that spreadsheet it
hangsup on me or freezes. I end up closing it out.

 

[Guest]

Their is only one spreadsheet it references and it is on our shared drive.

 

[Guest]

Here is what it should do:

'* Description: Gets the Service Center Work
'* Excel spreadsheet and imports it to Access
'* First, the information is imported as the
'* job tracking table in tbl_JobTracking. The
'* job information table in tbl_JobInfo can
'* then be built using the list of distinct
'* WMS numbers from the job tracking information
'* with the existing synchronization code.

 

[John Nurick]

This description doesn't mention linking.

Here is what it should do:

'* Description: Gets the Service Center Work
'* Excel spreadsheet and imports it to Access
'* First, the information is imported as the
'* job tracking table in tbl_JobTracking. The
'* job information table in tbl_JobInfo can
'* then be built using the list of distinct
'* WMS numbers from the job tracking information
'* with the existing synchronization code.

 

[John Nurick]

Use File|Get External Data|Link to create a new linked table connected
to the spreadsheet. Does this work normally? If you make changes to the
spreadsheet, do they show up in the linked table?