Paste tab delimited data into separate fields

[Chris Moore]

Access 2003 on Vista. I've got an application that provides me with a row of
data in a tab delimited format. Such as:

data1 data2 data3

I'd like to be able to copy/paste that data directly into an Access table
with corresponding data1, data2, data3 columns and have each piece of data
"land" in it's appropriate column. Is there any way to do this without using
an import wizard? Thanks.

 

[Jeff Boyce]

Chris

At one point (I seem to recall) there were issues with how that kind of a
copy/paste worked (?formatting, ?something).

An alternate approach might be to link to the tab delimited file, then use
an append query to load the data into the appropriately normalized Access
tables.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chris Moore]

Works perfectly in Excel but not Access...

Chris

At one point (I seem to recall) there were issues with how that kind of a
copy/paste worked (?formatting, ?something).

An alternate approach might be to link to the tab delimited file, then use
an append query to load the data into the appropriately normalized Access
tables.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Yah! But Excel is a spreadsheet and Access is a relational database ...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chris Moore]

Suddenly it's working. Seems that you just have to highlight the whole row
and then paste. Thought I tried that before but maybe not...

 

[Clifford Bass]

Hi Chris,

Paste Append (on Edit menu) is what you want. No need to highlight a
row.

Clifford Bass

 

[gllincoln]

Yes - highlighting the row is part of the process.

If you wish to paste into a new table - you need to delete all but the first
row, then highlight the first row and paste, otherwise the data being
imported will be limited to the number of columns in the default new table.

Gordon