tusharguptait Posted February 22, 2007 Share Posted February 22, 2007 Hi, I import data from excel to FM. Problem i am facing occurs when excel already has data which i clear and write new data. This new data should then be imported to FM. But FM still import the total number of previous rows. eg. number of rows in old data = 100, number of rows in new data = 10. (100 rows are imported with last 90 rows being empty.) Any solution to this problem will be greatly appreciated. Regards TG Link to comment Share on other sites More sharing options...
Fenton Posted February 22, 2007 Share Posted February 22, 2007 If you define a named range in Excel, and readjust it's size each time, then you can control which rows FileMaker imports. There's an option in the FileMaker Import (Excel) dialog to show Ranges instead of Worksheets. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6291 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now