copy and paste in access

[Guest]

I am having problems appending data in datasheet view when using append
data the paste buffer posts blank records.. any support would be appreciated

 

[dbahooker]

where are you copying from? IE? Excel?

I've never had a problem with how Access does this; of course; i
frequently have to paste from Excel into notepad and then into
Access.. or IE into notepad and then into Access.

there's frequently a whole bunch of other crap behind the scenes going
on; pasting it into notepad removes a lot of metadata crap

HTH

 

[John W. Vinson]

I am having problems appending data in datasheet view when using append
data the paste buffer posts blank records.. any support would be appreciated

Copy and paste is routine in Excel... but it's not ideal in the Access
environment. Append queries are MUCH more powerful and controllable.

Try using File... Get External Data... Link to link to your external
data source (Access table, Excel spreadsheet, text file, many others)
and run an Append query to move the data into your table; you can use
criteria such as IS NOT NULL on fields that would otherwise be blank.

John W. Vinson [MVP]