When you create (or reply to) a thread here there's a toolbar at the top.There are many ways to import data from an Excel file to a SQL Server database using: To contribute but IMHO their minimum contribution should be to provide feedback (even if not positive) and to mark as answer the solutions they get as this could help the few number of people who search here and there before asking something that's already
I totally understand people who can't/don't want ( or don't have time)
It's very personal but I don't see a forum/community as a one stop shop if you see what I mean. A couple of weeks later they haven't received a single word of feedback (whatever it is). Previous case 2 persons provided guidance and a 3rd was ready to assist assuming you would provide the same kind of information that is required on this one. My sincere apologies in advance for being straightforward but English isn't my native language My previous reply was to Renzo but now that you've written to me - as I'm polite - I won't leave you unanswered. I think that's it, but please ask again if I've missed anything? but it is MANDATORY that the UpdateTable/NewRecord is APPENDED to the CurrentTable, because the columns in CurrentTable that are populated by the users are dynamic ie they are populated (and amended) over time Has changed or not and do something with it if it has, that might solve another challenge I have!!!) I only want to import new records from each UpdateTable (but thinking aloud. the UpdateTable is supposed to ONLY contain new records, but it often contains a record that has already been imported into the CurrentTable. the unique identifier for each record comes from the UpdateTable ie when a new record is imported into CurrentTable, Column A is populated with the value from Column A in the UpdateTable
Auto import data from excel to excel update#
the users NEVER update any of the columns populated by the UpdateTable the CurrentTable contains columns that are ONLY populated from the UpdateTable and columns that are ONLY populated (subsequent to a new record coming across) by users. the CurrentTable and UpdateTable are in separate Excel files I can't see a way to attach examples, so let me see if I can do it with words? If it's possible I'm pretty certain it's going to involve some pretty complex stuff, but I am a reasonably advanced Excel user (but haven't come across this requirement before!). What I really want to do is use the various functions in Excel that allow me to point my table at a new update table and automatically import - and append - the new records into my table.
Auto import data from excel to excel manual#
Ĭurrently it's a pretty laborious manual task to get the new records (checking they're not already in my table!) - then copying/pasting the data from the new records from the update table into my table. In my table some of the columns are populated by the update table (others are updated directly by the user) - but the update table also contains columns I'm not interested in. Periodically I receive another Excel table from a third party system - again it has multiple columns - and each record has a unique identifier which is the same as the one in my table - the table should contain only new records, but that's not always the
I have an Excel table that has a number of columns - each record (row) has a unique identifier - but once in the table every record must be persistent ie an further records are appended to the table.
0 kommentar(er)
