Import Tables Facility

[rookery]

I want to try and code a facility wherby the user could import their exisiting table-data into my database. I suppose I want to try and write a wizard which would identify the table and database they're importing from, then link the relevent fields and import.

I dont want them to just use the "File-Get External Data" etc method. My problem is I'm not to sure where exactly to start. Can some one give me any suggestions? Is this as difficult as it seems?

 

[DougP]

Thats tough becasue there are so many variables
Is the Data ASCII?? Can you see it in Notepad?
Are the fields at the top of the file.
like so

Name, Address, City
Fred, 12344, Tampa
Sally, 2323, Largo

If so then you have to open the file and let them view it in a listbox or subform.
Here is how to open an ASCII file

open "c:\yourfile" for Input as #1
do while not eof(1)
line input Data, #1
debug.print Data
loop
close #1



DougP, MCP