Topics Search

paste a table into a cell

paste a table into a cell
Views: 1
Im trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

Ive tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow
Sponsored Links:

More topics

 

Paste a table into a cell

Preview
I'm trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

I've tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow
 

Pasting to Excel at a certain location?

Preview
I have a table (tbl1) and I want to transfer the data from that on to a template spreadsheet(spreadsheet1) which has headers etc already visible on the top.

I appreciate that its easier to use outputtoexcel etc but ive been told I have to use this spreadsheet to send my data on (lawyers eh?!)

I can create a new spreadsheet and paste the data across but what im wanting to do is automate the process, paste the info, send the email with attachment etc.

The bit in struggling with is how to get paste the info from my table to a certain point in the spreadsheet, cell A8 would be the starting cell I need to paste from.

Also if possible if we could do this with out the field headers from the table that would be brilliant if not I can write in a way of deleting the header line using a WITH function (I think, if im wrong here please point me in the right direction
 

Import single cell from excel

Preview
I need to import a single cell from an excell spreadsheet and place it into a textbox on an access form, I understand the easiest way to so this would simply be to cut and paste.

but here is the crux of my problem I need to do this for multiple cells and paste into multiple textbox's for data that changes on a daily basis, and essentially on the click of a command button.

I have attempted to use the TransferSpreadsheet method but I believe I can specify a range of cells but not a single cell,

In a nutshell I would like to replicate my spreadsheet in access by mapping each cell to a textbox
 

Import single cell from excel

Preview
I need to import a single cell from an excell spreadsheet and place it into a textbox on an access form, I understand the easiest way to so this would simply be to cut and paste.

but here is the crux of my problem I need to do this for multiple cells and paste into multiple textbox's for data that changes on a daily basis, and essentially on the click of a command button.

I have attempted to use the TransferSpreadsheet method but I believe I can specify a range of cells but not a single cell,

In a nutshell I would like to replicate my spreadsheet in access by mapping each cell to a textbox.
 

Filter time shows wrong result, bug in Access or Excel?

Preview
Have a table in Excel 2010 with a column formated as hour:minutes:seconds (00:00:00). First row is 00:00:00, second 00:00:01, and so it continues to 00:05:00.

Have a table in Access 2010 with a field formated as date/time, hh:nn:ss. Copy column from Excel and paste into Access.

When doing some filtering in the table (right click in the first cell "is like 00:00:00", But when I try som other, I.e. 00:00:04, access won't return any result.

I have tried on several pc, and several versions. But I think Access or Excel must have a bug. I can override the problem by choosing paste as special, and choose paste as text instead of paste as excel
 

Cell Counting? Is that what you call it?

Preview
I have a cell in a column B1:
MJTB1001

I need to paste to approximately 235 new rows in the column B1 as follows

MJTB2002
MJTB3003
MJTB4004. etc.

What formula should I use to accomplish this task?

Also I have the cell MJTB2044 and I need to make 235 new cells in column to fit like this.

MJTB2044
MJTB3044
MJTB4044
MJTB5044 . etc. until the middle B5=B235 etc.
 

Filter time shows wrong result, bug in Access or Excel?

Preview
Have a table in Excel 2010 with a column formated as hour:minutes:seconds (00:00:00). First row is 00:00:00, second 00:00:01, and so it continues to 00:05:00.

Have a table in Access 2010 with a field formated as date/time, hh:nn:ss.

Copy column from Excel and paste into Access.

When doing some filtering in the table (right click in the first cell "is like 00:00:00", the query shows the result ok.

But when I try som other, i.e. 00:00:04, access won't return any result.

I have tried on several pc, and several versions. But I think Access or Excel must have a bug.

I can override the problem by choosing paste as special, and choose paste as text instead of paste as excel.
 

Multiple record paste

Preview
I'm sure this has been asked a hundred times, but I cannot find a good answer. In a table, I am trying to copy paste from one field, one record (cell), into multiple records of that same field or any field I wish. Basically, I would love to highlight any range, whether it is single or multiple records and rows, and paste over where I choose. So if in records 1, 2, and 3, I highlight and copy the values in field A, how do I paste these values in records 4, 5, and 6 of field A, B, etc. I know I'm thinking in Excel mode, but I generally do not manually input my data in Access, but rather dump reports through Monarch
 

Importing cell notes from excel

Preview
I have a lot of data stored in cell notes in excel, I need to get these into access, its only 2 fields worth in access, but I need access to realise that new data on a new row in the comment means a new row in access. For example:

(cell comment):

(Access table):
date reading
row 1: 05/03/2009 556,675
row 2: 05/04/2009 557,675

is this possible? There are a few thousand of these that I need transfered over so doing it with copy and paste is taking too long
 

Return all results in one cell/As one block

Preview
I'm saving email address for contacts in a database. I want to send an email to all the contacts and I need the emails to be like one block. That will make it easier by just copy and paste it in the To field in an email.

I've got the data in a table as:
a@b.com;
c@d.com;
e@f.com;

And I need it to be as:

a@b.com; c@d.com; e@f.com

how can I make all results appear in the same cell not as a table