I want to import date(Mar-08) from text file into Access, in the same format. how it is possible. Plz quick reply me...:confused:

Thanking You,
Ashish

1. Import the text file into a new Access table.
2. Create an append query that will copy the data you want into the appropriate existing table.
3. Delete the new table.

1. Import the text file into a new Access table.
2. Create an append query that will copy the data you want into the appropriate existing table.
3. Delete the new table.

Hi statsman;

I do the same process, but I think this is not a proper way. In this way we waste the time. I want a way in which at importing time there should be a option for selecting. can u help me, plz....

Hi statsman;

I do the same process, but I think this is not a proper way. In this way we waste the time. I want a way in which at importing time there should be a option for selecting. can u help me, plz....

Nope, you will either have to import it all and discard what you don't need or you can edit the import file first and import the resulting file. The time savings would be on the side of importing it all and then discarding what you don't want.

there is nothing wrong with importing to an interim table, then finalising

it gives you the added benefits of being able to verify the new data is correct before using it. what if you selected completed the wrong file to import, and didnt validate it first.