Working with exported data and linking to a database

N

Nicole

The base of my database is data that is exported from another program into a
tab delimitated format. I have linked this data to my database, but it is
in-efficient.
Please give me suggestions on the best way to utilize the data. I have
messed with splitting the linked table, but then the data is no longer
linked.
I need to be able to update the data when the information is exported again
in the future.

Any suggestions would be greatly appreciated!!!
 
S

Stephen

Why not import the text field data into your database as
an Access table. You could develop a set of delete and
append queries and macro to speed the process.
 
D

Damien McBain

I have a similar process (text file export from SAP) in one of my apps. I
use this code to import the contents of the text file into a table each time
the ap is used, (after deleting the existing contents with a delete query)
then run a report on the new data.

Private Sub GetDataButton_Click()
On Error GoTo Awwwshit

DoCmd.OpenQuery "DeleteData", , acEdit
DoCmd.TransferText acImport, "ImportSpecs", "Data", CurrentProject.Path
& "\" & Forms!GetData!Path & ".txt", True, ""
DoCmd.OpenReport "EUT Report", acPreview, "", ""

gtfo:
Exit Sub
Awwwshit:
MsgBox Err.Description
Resume gtfo

End Sub
 
Top