DataBase - Paste Special, Values, Transpose
Asked By Jim
20-Jan-10 09:05 AM
Is there a way in Access 2007 to use the paste special features available in
Excel? I have data in Excel that I will be copying and pasting into a form
in Access. Importing would be tricky because not all tickets on the
spreadsheet need to be copied.
The issue is I receive the spreadsheet from another workgroup and they have
merged cells and have the data going down one column, 19 rows. I can copy,
paste special within Excel to get the data formatted right, then copy it into
Access. I am hoping there is an easier way.
Any suggestions?
Thanks!
Jim
Access 2007
(1)
Excel
(1)
Repetetive
(1)
Daryl S replied to Jim
Jim -
A copy/paste special in Excel sounds easy enough. You do not have that
option in Access. If this is a repetetive process, then I would suggest a
macro in Excel to clean up the data, putting it into an empty worksheet.
Then you could import or copy/paste from that into Access.
--
Daryl S
Access 2007 provider for windows 2000 DataBase I wish to connect Excel 2007, Access 2007 and was getting provider error. I tried to install Microsoft patch AccessDatabaseEngine.exe, but it My server is of windows 2000. Plz anyone tell me how can I connect it. Access Queries Discussions Access 2007 (1) Excel 2007 (1) Plz (1) Windows (1) is there any reason you are
Esportare una tabella Access 2007 in un file excel DataBase Access 2007 / Excel 2007 / windows xp professional In realta' sono alle prese con un grosso recordset ADO costruito con in left join su diverse tabelle. Questo recordset ha troppi record per poter esportarlo in excel tramite un ciclo di questo tipo : do while not RC.eof for j = 0 to
Access 2007 Excel Import Error DataBase I am trying to import an Excel spreadsheet into Access 2007 and keep getting all blank rows, columns, tabs, formatted all the data to match Access, etc. What is this "search key"? - - Thanks! Access Discussions Access 2007 (1) Error (1) Excel (1) Excel Import (1) Import (1) Excel spreadsheet
RTF data from Excel 2007 to Access 2007 DataBase Hello I cannot transfer RTF data from Excel 2007 to Access 2007. When transfering RTF data to Access the formatting is omitted. I have tried to import
Link Access 2007 to an Excel 2003 worksheet DataBase I have an Access 2007 data base and I am trying to link Excel 2003 worksheets to it. Anyone know of a way to do this? Not all users have Excel 2007. Access External Data Discussions Access 2007 (1) Excel 2007 (1) Excel 2003 (1) TransferSpreadsheet (1