import data

[Tiffany]

Hi,

I have a database in Access. The source data file is .dat. Is there anyway I
can create a automatic uploading procedure to directly upload the data in the
..dat file to Access. I am using Acess 2007.

Kindly advise.

Thank you.

 

[Jerry Whittle]

Hi,

The first thing to do is import the dat file manually. Write down all the
steps that this takes including if you need to do things like change the file
extension from .dat to .txt; import directly into a table or create a new
table; use an import specs; or any other problems.

Also you may want to consider linking to the .dat file instead of importing
it. You then could use update or append queries to put the linked table data
into your tables.

I think that the first problem will be with the .dat file extension. Access
2007 doesn't seem to support it for linking or importing. I do not know if
there is an add-in or registry hack to allow it.