Forums :: Import/Export Tools

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Import/Export Tools

DwZone Forum Index -> Import/Export Tools

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 121 to 130 of 382 (Total: 233)

First | Prev | Next | Last

Subject

Author

Date

Re: Import excel to Access

Laurent Dagany

14:51 14 Apr 2011

Thanks for your answer.
I think the fonction "update" in case of duplicate content is the good option I need.

You speak about a new release to install... First, I didn't find it because you didn't change the number of the version (1.3.9).
But finely, I installed this new version 1.3.9, killing the DW cache (the path to the cache in Windows 7 is now a little different by the way), replacing the files dwzExport on the server, and I choose "update" in the dplicate entry field.

After having problem to understand the trick between the unique key column of the database and the one in the excel file, and also to not forget to make a range name in the excel file, finely I did it !

Questions :
* is it possible not to have a range name, or is there a default range name in all the excel files ?
* Do I have to have a fist column in the excel file with the numbers of the line ? No way to use the automatic numbers of line of the excel file ? (the excel file generated by the results software doesn't create any column of number of line. So my clients will have to make it, which is not convenient for race with 150 lines for 150 boats).
* When update is done, it doesn't delete the records thats could have benne deleted from the excel file ?

Thanks for your answers