Importing data into sql 2

[kporters]

Can someone give me a clue as to Importing data into my SQL db without being on my SQL server? I'm using Access as my front end and need to update the data in SQL by importing text datafiles into my SQL db. I would like to use Access as a front end app to import data into my SQL db.

thanks in advance,
-K

 

[DrewConn]

There are a lot of different ways to do this but this may be the easiest. Use the import text wizard in Access to get the text file into a temp Access table. Then create an update query to update the data in the sql table. This assumes of course you have the user access to do updates on those tables. Hope this helps.

 

[balves]

One way is:

- import the text files into local tables in an Access database

- create linked tables in the Access database that point to tables in the SQL Server database

- write Append queries in Access to send the data from the local tables to the linked tables.