LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default New Excel data does not appear in linked Access table

I have an Excel2000 worksheet which contains 5 columns of data. I created a
table in Access97 which is linked to the worksheet.
For the last year, any data added to the worksheet appears in the table.
Now the worksheet exceeds 1,683 rows. All data in rows 1684 and beyond does
not appear in the table.
The worksheet has never had any Named Ranges. Following the suggestion in
article 197232, I defined a name range which included data in rows 1 to 2000.
Data in rows 1684 and beyond is still not visible in the table.
Is the "restriction" in Access or Excel? How can I get around this

Thanks for any suggestions.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
create excel spreadsheet on a data access page Pitu Excel Discussion (Misc queries) 0 October 3rd 05 08:11 PM
Access Query Linked to Excel fixed rows Chris Edmunds Links and Linking in Excel 3 September 3rd 05 07:42 AM
Password protection of Excel Sheet linked to Bloomberg Data Rohit Excel Discussion (Misc queries) 0 June 28th 05 10:29 AM
Error Printing Excel 97 linked to access 97 on NT BenAshdown Excel Discussion (Misc queries) 0 April 27th 05 12:16 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 08:54 PM

All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"