MS Access Data Paste Question

[sgreenwood]

Hi,

Hopefully this will be an easy question. I have a blank column in an Access table. I want to type "Trade A/P" in the first field and then copy it down the entire column. Is there an easy way to do this??

I tried doing it as I would in Excel....copy the field then highlight the rest of the fields in that column and paste....but it only pastes to the first field in my highlighted range.

It seems like there must be an easy way to do this without having to create some query to insert the value.

Any help would be greatly appreciated.

Thanks,
Steve

 

[Edrondol]

If that's the only thing you want in the column (assuming no other data in any other records), you could go to the design mode and in Default value put Trade A/P.


-Dave

 

[Rick39]

Hilight the column, select Edit Menu ->Replace

 

[Edrondol]

I have Access 97 and that doesn't work, Rick. It wants something in the "Find What" field. In any event, if Steve wants this to continue even on new records, I'd still go with adding it to the Default Value. But I'm stubborn that way....


-Dave

 

[udik]

Hi Steve,

You can create the stuff in XLS and import it to MS-ACCESS using File->Import...

Another idea - if this info repeats for the whole column, consider to simply create additonl table with this info as row and link them. This is probably the correct solution, you'll avoid duplicate information in your table and you'll save space