Import / Export data

I am currently trying to import and export data to some external file that preferably is made as required but I want to use SQL if possible to read it (and make it would be nice).

I am useing Access 2000 and some PCs may use 2003 any ideas / help / code snippits?

Search the forums for other posts I made :

Functions to read up on:
Open <filename> for <type of open> as <channel>
Close <channel>
Print #<channel>,<string>
Line input #<channel>,<stringbuffer>


Vince

Thanks.

I've been fishing about and came up with this:

VB Code:

Private Sub MakeFile(CalledThis)
'This sub is called to create an mdb file to store the data in.
Dim AccessApp As Access.Application
 
On Error GoTo SameName
    
    Set AccessApp = New Access.Application
    
    With AccessApp
      .NewCurrentDatabase CalledThis
    End With
    
GoTo SkipThis
SameName:
    If Err.Number = 7865 Then
    MsgBox "ALERT: There is already a file with the name: " & vbCrLf & """" & CalledThis & """" & vbCrLf & "and the system is trying to use it." & vbCrLf & vbCrLf & "If this file is important please move it now.", vbCritical, "Name error"
    End If
SkipThis:
End Sub

Which has worked nicely.

however the import section has me stuck now... but it's a SQL issue. :blush:

?

So what do you need?