Computer Support Forum

Exporting from Access to Excel-length limits?

Question: Exporting from Access to Excel-length limits?

Hi all,
I am wondering how to overcome the problem of Excel chopping off data.Is there a way to set a large limit or possibly keep the record length unlimited.This data is the results retreived from Access queries. The data after querying is exported to the Excel sheet via the following do command:

DoCmd.OutputTo acQuery, "queryName", "MicrosoftExcel(*.xls)", "Report" & ".xls", False, ""
Thanx

Relevance 100%
Preferred Solution: Exporting from Access to Excel-length limits?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Exporting from Access to Excel-length limits?

If you are trying to put the entire string as one line it will never work. I believe the charachter length is 255. You can however create a new cell in Excel for each record like a line break.

3 more replies
Relevance 84.46%

I'm trying to get a longer cable for my digital SLR camera, so I can live preview / shoot from the computer. The camera has about a 3 foot cable with a special USB end.

I was just going to order a 15 foot usb extension cable, but this would put me at a total of about 18 feet. Will this extra 2 feet matter? I've read various things about this, most of them saying that if the computer can't output enough power for the cord, that is when you have a problem.

I will be connecting to my Dell studio XPS built in USB port.

Thanks

Jamie

Answer:Are USB Cable Length Limits hard limits?

It probably will matter. Perhaps a powered hub in between may work:

USB.org - USB FAQ

1 more replies
Relevance 74.21%

I am having to attend a clients site this week to troubleshoot connectivity issues. I don't know if its Wifi or his actual link to the internet (via radio) that is the issue.

Part of the information given to me is that he has AP's on ethernet runs in excess of 300 feet. I think 350' was the number I was given. This guy is going to be one of those difficult guys, as he presents himself as an "I/T person", and this wiring "worked before"....

So this is a bit of pre-visit leg work. ...and here come the questions...

- The recommended maximum run for ethernet is 280', allowing 10 at each end for connecting equipment...300' total.

- is it ever "OK" to go beyond that.
- what actually can happen at excessive lengths?
- is there a way to "boost" the signal so it can travel the distance?

These are straight from the VoiceMail Iw as forwarded.

I hate to be the bearer of bad news on jobs like these, but I have a feeling about this one....
I would think he'd be better served by some kind of wireless bridge, the kind of thing I've put in at other locations. While this is may be the case, the above situation is what I am going to have to address.

S~
 

Answer:Ethernet length limits

8 more replies
Relevance 72.98%

Hi, as you can see from the title i want to export all the data in my access table to an excel spreadsheet. How do i go about this?

Any help will be appreciated.

Thank you.
 

Answer:Exporting an Access table to Excel

16 more replies
Relevance 72.16%

When I Export from Access to Excel..to a External file then when I chose the "Save as file type"..Excel is no longer an option..and there's a Message "Not all file types are installed..& to re-install office 97..click Add/Remove Data Access, Change Option..

If you un click the rest & just leave Data Access..that will mean uninstall everything & install Access only..So I just installed everything..

Still...the same..any suggestions...is there something wrong with my OS
 

Answer:{Resolved} Trouble Exporting From Access To Excel

8 more replies
Relevance 71.34%

I have a new laptop using Win7 Home Premium and Office 2010.
If I export a file from Access to Excel the exported data keeps the original Access formatting of Calibri 11 point but the blank cells in the Excel spreadsheet all reduce in column width to 5 and the font changes to MS Sans Serif 8 point.
Any ideas what I am doing wrong.

More replies
Relevance 68.88%

Hi all,

I have a report in Microsoft Access that I have to regularly email out to people. I use a SendObject macro to create the email content and automatically attach the report as a .xls document. I recently changed the report and associated query column headers, which are working fine. When I look at the report in Access, it looks exactly howI want it to look. When I email it, however, the automatically attached Excel document has the old column headers (the content is fine). This does not happen if I hit the "Export" button and export the document straight to Excel. The same problem occurs whether I use the macro or the e-mail button on the Windows drop down menu. Can someone please explain what is happening and how I can fix it?

Many thanks,

Rebecca
 

More replies
Relevance 63.14%

I'm having difficulty with an export I am trying to do. I have used the help in Access with both the TransferSpreadsheet and OutputTo actions, but they both produce the same result. They create an Excel file, but I can't open it.
Code:
DoCmd.OutputTo acOutputQuery, "qryLegacy2004", acFormatXLS, "LegacyIssues2004.xls", True
or
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryLegacy2004", "LegacyIssues2004.xls"
yes, I am deleting the file before I try again.. am I doing something wrong?
 

Answer:Exporting query from Access 2000 to Excel 2000

6 more replies
Relevance 58.22%

So im using Excel 2010, and i making a timetable.

Right now the row going across saying period 1 2 3 they are all different sizes, some will be bigger and some would be smaller. I was wondering if there is a way to make them all the same size.


If you dont know what im talking about ask for a screenshot.

Im to busy to upload one now

Answer:Row Length in Excel

do you want the rows to all be the same height?

click on the first row number on the left - shift-click on the last one to select all the rows.

then right-click on the row numbers >> row height >> type in a number...

you can do a similar thing with the columns too.

is this what you meant?

4 more replies
Relevance 57.81%
Relevance 57.81%

Not very fluent in Excel. I am setting up a positive pay format for my company to transfer check information from my PC to a bank via an ASCII Flat-File. Question is, I have so many columns that need to be set at 10 characters fixed length.

Is there way for this to be done? Example if I key in a check for $1.95

I want it to automatically put it as 0000000195.

Can this be done?

Thanks
 

Answer:Fixed Length in Excel

6 more replies
Relevance 57.81%

I am new to Excel and can't find out how to limit my "book" to 2 pages. I know how to print only 2 pages (the other 424 are blank and will remain so) for my own purposes. However, I am e-mailing the file to others, so I want to simplify their work by eliminating the blank pages.

Still looking for a way to convert this to Word....

Thanks in advance for your help!
Tricia
 

Answer:Excel - document length ???

10 more replies
Relevance 57.4%

These are going to be greatly increased from the current 65,536 * 256 limitation click hereThis is great news but it means that if you have used code likeLastRow = Range("A65536").End(xlUp)to return the last used row, it may no longer function correctly.The following will work:Sub test()Dim LastRow, LastColLastRow = Cells(Rows.Count, 1).End(xlUp).RowLastCol = Cells(1, Columns.Count).End(xlToLeft).ColumnMsgBox LastRowMsgBox LastColEnd Sub

Answer:Excel 2007 Row and Column Limits

Say that again in English.

6 more replies
Relevance 56.99%

I have 2 Excel files that I create for my company, a list of items we sell, one with prices and one without.  I use 2 columns on a page for both of them.  Other than the prices, they are exactly the same.  However, when I print them out, the one with prices breaks one row lower than the other, even though the margins, row height, and other page setup settings are exactly the same, as well as the printer.  I would like to make them the same, as it makes it easier to copy and paste new data between them.  Any help would be most appreciated.
 

Answer:Excel worksheet page length

A suggestion for a quick and dirty fix !  You say it is the list with the prices that is breaking one row lower. Go into 'Print preview' and 'Setup . . .' and increase the bottom margin very slightly, say by 0.1 cm. this should make it break a row earlier to match the other.
 
Apart from the elegance aspect, does it make a difference that it is the printed version that is showing this behaviour ?  Surely, any copying and pasting you are doing is done on screen and you imply that any misalignment is only showing up in the printed version.
 
Chris Cosgrove

3 more replies
Relevance 56.17%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 56.17%

My lady wife is having a small problem with a formula she is trying to use in an Excel spreadsheet.

She is trying to make a formula that she can copy and paste into various spreadsheets she utilises to organise her staff's workflow.
The five staff deal with about 30 suppliers and she wishes to be able to associate each supplier with a particular member of staff, so, for example, if column A is 'Suppliers'and column B is 'Staff Member', a formula using the IF function is placed in column B using the following syntax:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark","")))))Click to expand...

This works just fine with only a few suppliers, but if the string is lengthened to more than about 9 suppliers, as here:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark",IF($A1="ffff","Rashmi",IF($A1="gggg","Laura",IF($A1="hhhh","Linda",IF($A1="iiii","Denise",IF($A1="jjjj","Mark",IF($A1="kkkk","Rashmi",IF($A1="llll","Laura",IF($A1="mmmm","Linda",IF($A1="nnnn",&quo... Read more

Answer:Solved: Excel formula length problem

11 more replies
Relevance 56.17%

Excel has a limitation of 240 characters when saving a file as .PRN. I need to create an ASCII file of greater record length with multiple records.How can I do this? Is there an Excel workaround or will I have to use another program? Will Access allow me to do this?Thanks for any assistance in advance.Squeals

Answer:ASCII fixed length files in Excel

You MIGHT be able to do this using a macro click here

2 more replies
Relevance 56.17%

Hi i am Jo

would need help in finding the length of the third side of a triangle in excel

I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,
 

Answer:Find length of side of triangle in Excel

Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.
 

3 more replies
Relevance 55.76%

I am exporting a report from the web into an excel database. The web report numbers are being pulled in the excel database with Look Up Formulas. The web report data will not pull over using this formula in the excel database. Is this because the web report is being pulled from the Web? If so, is there anyway I could pull the web report data over into my excel database.

Thanks so much,

Tammy
 

Answer:Excel Question, Exporting from the Web.

A question Tammy - is the web report in Excel format?
 

1 more replies
Relevance 55.76%

I am trying to export a table from access 2000 to excel 2000 and keep getting an error message
"external table is not in the expected format"
What should I do
 

Answer:error exporting to excel

How are you trying to export the table? Are you using a macro or are you clicking FILE --> EXPORT?
Rollin
 

2 more replies
Relevance 55.76%

I know how to export a chart as a .GIF file:Sub GifCht()Dim FName As StringFName = Application.InputBox(prompt:="Please enter File name", Title:="Export chart", Type:=2)ActiveChart.Export FileName:="L:\Results\" & FName & ".gif", FilterName:="GIF"End SubDead easy!How do I export a chart as a .BMP? There is no clue in the MS Help or Knowledgebase (correct me if I am wrong) and I can't find anything on the Eccel sites that I visit.A forlorn hope... ?

Answer:Excel chart exporting

Can you not just export the chart as a GIF and then convert it to a BMP in a paint package?RegardsFitshase

10 more replies
Relevance 55.76%

Hi, a friend of mine has written an Excel worksheet with a Macro using bit of VBscript added in which is used to read in a student's grades and output a final overall grade. We were wondering, that there must be a way to be able to incorporate the script to basically make a web-based version of this....

Can anyone help?
 

More replies
Relevance 55.35%

Hi i have worked up a quote for a potential client in microsoft excel. I want to make it to where he can open it in word or a similar program without any problems. When i tried to open it in word it said i needed to install something. Is there anyway to bypass this so it can be opened with ease? Also i want to make it to where he cannot modify it at all. any ideas????
thanks
 

Answer:locking and exporting excel files

Without the converter, no you can not easily open up an excel document in word. The formatting is different - unless you want to write up some code to create a word document from excel...I think your client may have to use Excel. You can protect your workbook from being modified - go to Tools -> Protection. You can set up the workbook to have a password to save changes. If you look up the term 'protection' in Excel's Help you'll be able to find details on how to do what you want to do.
 

3 more replies
Relevance 55.35%

I have two alerts for Sensitive Account Credentials Exposed, "Credentials were exposed in cleartext using LDAP simple bind.  He of these alerts are showing as being from several source machines using several different user accounts.  When
the alerts first started the console would should the first date detected 1/10 and the last date detected 1/23.  If I would export the data to Excel I would see all of the detected events 1/10 - 1/23.  I fixed all the problems and marked the events
as Resolved.  
Several days later the events showed back in the ATA console as detected and the date range was up to the current date 2/3.  However if I export this data to Excel the last date displayed is 1/23.  I see a new user on the Exposed tab, but on the
Network Activities tab I do not the new date, only up to 1/23.  I have 10001 rows on the Network Activities tab.

More replies
Relevance 55.35%

I am trying to export some tables from OneNote to Excel.

Everything I have seen online has a convert to excel in the table tools(from the Insert Tab) button or a Excel button in general but my version 2010 of OneNote does not have this.

Does anyone know of a way where I can convert the tables I have in OneNote to an Excel Spread Sheet??

Is there a plugin or add on I need to install for this?
 

More replies
Relevance 55.35%

I'm having a date format problem when I merge from Excel into a Word document. Instead of 3/1/10, I want it to read March 1, 2010 (U.S. style, with month spelled out). I can correct the format in the spreadsheet, but it still exports as 3/1/10. Does anyone have a suggestion?

Thank you from Miss Eden in Bar Harbor, Maine.
 

More replies
Relevance 55.35%

Each time I try and do this it comes up with the error message

An error has occurred in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file..........has no named ranges. Use Microsoft Excel to name the range of data you want to import.

I do not know how to do this, can someone help?

Thanks.
Miadelcara
 

Answer:exporting excel to outlook contacts

6 more replies
Relevance 55.35%

Hi all

I'm fairly new to this forum stuff so please bear with me if I have done this incorrectly or posted it wrong....!

Basically I have been asked to update our current lotus.123 (DOS) management accounts to excel, but there are quite a few tricky macros within lotus that I am not sure how to convert.

We use a csv file to download our nominal ledger into, and the first macro imports this data and saves it as an excel file based upon a cell reference. i.e.18N0507 where cell A3 gives date to reference last four digits. Before closing the file, and opening another template file.

How do I import data the csv file and save it with a specified name based upon a cell ref?

The next macro will then import the month actual, month plan, ytd plan, and ytd actual into the template just opened. Each or the imported files will be again based upon varying cell references. Before finally saving the template file with all exported data as a temp file. i.e. 18temp

Each of the templates is protected apart from the data entry cells, and those cells where the data is imported into.

I'm ok with linking files etc, but the macros used in lotus actually import specific cell references from specific files, and then automatically rename the file that the data is imported into.

I'm afraid this is a little above my skills, although the macro formula in lotus looks so easy??!

One of the other problems I have is that the accounts can be run in draft forma number of times b... Read more

More replies
Relevance 55.35%

I have a form that is in Microsoft Word format and I am trying to pull information from Excel for highlighting. I am looking for Word to check the contents on the Excel spreadsheet and highlight the area on Word if necessary. Does anyone know how to do this? I have already incorporated the mail merger feature on this form and an envelope, however I would like to highlight the necessary areas of the form depending on the contents of the spreadsheet.
 

Answer:Exporting Information from Excel to Word

8 more replies
Relevance 55.35%

hi,
I am looking to export data from an excel file into Bing to create an itinerary. How can it be done?
Thanks you to get back to me please.

Joce

More replies
Relevance 55.35%

Hi everyone,
Please bear with me as I can't seem to find an answer to this... My scenario is as follows:
1. I have a worksheet set up in Excel 2010 with different columns like names, addresses, phone numbers, etc. Let's say I have Column A, Column B, Column C, Column D, Column E, and Column F.
2. What I want to do is run a query (?) that, for example, takes ONLY the data from Column A, Column D, and Column F. Then it dumps that data and that data only into a new (blank) Excel sheet for to view, print, etc that is independent from the original worksheet.
How does one do this?

Answer:Exporting data OUT of Excel 2010?

OH MY LAWD!!! First excel related question I've seen lol.. Eh would you like to dump the result in a new sheet of the same excel file or a totally new one?

3 more replies
Relevance 55.35%

Hey OBP if you're around, I have a situation. I have a company that it would be easier to manipulate their data via spreadsheet than creating a report. Is there an easy and fast way to send their assets to a spreadsheet?
 

Answer:Exporting part of database to excel

8 more replies
Relevance 55.35%

Hello Everyone:I have a VBA macro designed to take a whole bunch of Modbus addresses entered into a list and then export specifically-named csv files from Excel. My code is below. It works beautifully, with one small problem. When I enter addresses into the list sometimes not all subsections of the list are filled, in which case there should not be a csv file created for that particular subsection. Unfortunately I'm getting some csv files that are 0 kB exported as a result. This wouldn't be a big deal except I grab all of the exported csv's at once and then import them into my other piece of software. Because of the way they are named the importing software does all the work!To use this sheet I put the title name in column A and copy it all the way down. Column B gets the subset name (could be a variety of things) Column C has a listing of attributes under each subsection name, and finally column D is where I 10-key in the Modbus addresses, where applicable. Anyone have any ideas? I'm not sure how to paste my code into here and made it actually look like code either. If anyone could advise for future posts I would certainly appreciate it. Thanks so much!Sub Export()Dim num_rows As IntegerDim filename As StringDim Filelocation As String'Save the CSV Files to this locationFilelocation = "C:\Documents and Settings\CSV_Exports"'Cell A5 is using the counta function, taking a look at the total entries in column A for which to apply these forumlasnum_rows = Range("A5").Va... Read more

Answer:Excel VBA Macro - exporting csv files (0kB)

1 - To post VBA code correctly (and thanks for asking!) click on the How To in my signature line.2 - I haven't really looked at your code (yet) to see what it's doing, but maybe you could explain this statement a little more:When I enter addresses into the list sometimes not all subsections of the list are filled, in which case there should not be a csv file created for that particular subsection. What is a "subsection"? Is it a range? Is there something we can key off of so the code will say "Hey, that range/cell is empty, skip the csv creation"?Posting Tip: Before posting Data or VBA Code, read this How-To.

6 more replies
Relevance 55.35%

I have a spread sheet ( MS Excel 2002 ) telephone directory where one of the columns contains the Phone Numbers.The Phone numbers can be either "Internal" numbers comprising 8 digits, e.g. 12345678, or "National" Numbers which require a "9" to be dialled to get an outside line, so are listed as 901234567890 etc. I need to export / save the phone number list as a Comma Separated Value file ( .csv) for use in another program, but when I do this and then open the .csv file all the "National" Numbers have been coverted to some sort of engineering code, and appear as "E+113456" or similar.I have tried formatting the relevant cells as "Number" with 0 decimal places etc, but the above still happens.Anyone know how I can save the file as a .csv file but retain the original format, without it converting to this engineering code ( or whatever it is ) ?Cheers.

Answer:Excel - Exporting to a .csv file problem

To get them to export in the desired format you would need to convert them to text by preceding them with a ' e.g.'901234567890If there is a long list this would be tedious. Say the numbers are in Column A starting at row 1 then in B1 enter="!"&A1and copy the formula down. Then select column B, Copy then Edit > Paste Special and choose Values. Then delete the original column A. Save the file as a .CSVOpen the CSV in Notepad, Edit > Replace, enter ! for what to replace and leave the replace with box blank.

4 more replies
Relevance 55.35%

HI All,I would like to create a script which i can Click, where it will export a .txt file with the information in D7-D18 and also if it can save the file with what ever is in a box in Excel?Ta,Leo

Answer:Excel Exporting apart of my Speadsheet to a .txt file

re: "if it can save the file with what ever is in a box in Excel?"What do you mean by "a box in Excel"?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 55.35%

I have 2 colums that I need to export from excel into word as comma seperated values. Anyone have any clue how to do it?
 

Answer:Solved: Exporting data from Excel

You can save the data as a comma seperated file and then open with word and copy and paste into the word document where you want it.
 

2 more replies
Relevance 55.35%

Hi guys

I am using Office 2007 and am unable to find this information else where on the form.

Heres the scenario:

I have 3000 different excel files that I wish to extract data from, possibly using VB. This data will be used to put into a table in Access (however, it may be imported into an excel sheet and copied accross if easier.)

Each Excel file consists of exactly the same template, with different information enclosed in this template. I need a script that will extract the values of certain cells (the same cells everytime) in the sheet and input into the table (or final Excel sheet). This script needs to be able to run on every Excel file within a certain folder.

In addition to this, it needs to grab the last date in a date column and copy this into a single date field at the top of the sheet.

I know this a small request , but in theory if this is possible I would really appreciate someone to help me a little.

Please note, I have no previous experience with VB, only amateur excel formulas.

If there is anything else that would help people understand the issue I will be happy to forward any information.

I dont expect to be spoon fed but I am on a really tight schedule, I hope that the answer can be beneficial to other users.

Rowan
 

Answer:Solved: Exporting Excel Data

16 more replies
Relevance 55.35%

How do i export a public contact list into excel. I can export the private contacts with no problem but there is no choice for the public folder nor does it give you a browse option. If there is a way to fix this or get around it please let me know
 

Answer:exporting contacts outlook xp to excel xp

As I recall...

You must first download the global address list to your PC. Do this (somehow) through Tools-Services and choose something like "make available offline" or something like that.
 

3 more replies
Relevance 55.35%

Hi there

I know that it is very easy to copy and paste an Excel worksheet into a notepad. However, my boss wants me to write a macro in Excel that can do that automatically, since we have staff that is not comfortable in using Excel. I tried to record a macro to get me started but that did not work. Any ideas??

Mario
 

Answer:Exporting an Excel worksheet into Notepad

16 more replies
Relevance 55.35%

Hi All,

Having some trouble exporting modules from code. Not sure why. Any help would be appreciated. I am getting Run-time error '50012' Method 'Export' of object '_VBComponent' failed. I am using an .xls workbook in Excel 2007.

My code is below, but the export breaks even when I do this:
Code:
strPath = "C:\ReplaceTaxCode"
ActiveWorkbook.VBProject.VBComponents("ToolsA").Export "\" & strPath
Full Code Here:

Code:
Public Sub ReplaceCode()

Dim wkbCode, wkbReplace As Workbook
Dim strPath
Dim VBAEditor As VBIDE.VBE
Dim objProject As VBIDE.VBProject
Dim objComponent As VBIDE.VBComponent

Set wkbCode = ThisWorkbook
Set VBAEditor = Application.VBE
Set objProject = VBAEditor.ActiveVBProject

strPath = "C:\ReplaceTaxCode"

For Each objComponent In objProject.VBComponents
objProject.VBComponents(objComponent.Name).Export "\" & strPath
Next

End Sub

 

Answer:Solved: Excel VBA Exporting Modules

7 more replies
Relevance 54.53%

Can anyone please tell me where I can get a simple set of instructions on how to export several colums of contacts in Excel 2007 into outlook 2007. Thanks Tim
 

Answer:Solved: Exporting from Excel 2007 to Outlook

16 more replies
Relevance 54.53%

Hi all,

I have Windows 7 Professional and am using IE9. There's a website we use at work that needs data exported to excel. It works on my co-workers older computer but not from mine. I've attached the screen shots. When I right click on the screen, it gives me an option to export to excel. When I do, It gives me the screen that's says I'm not connected to the internet, which I am or I wouldn't have been able to go to the website in the first place. Anyone know of a fix? I tried downloading IE8 but it says it's not compatible. Any help would be great.

Thanks.

Answer:Trouble exporting data to excel from website via IE9

Use the browser window that pops up from excel (the dialogue that says you're not connected to the internet) to navigate to the webpage with the data you want to import. There will be yellow arrows to click on for the data you want.

Why it's done this way doesn't make sense but it should work.

1 more replies
Relevance 54.53%

Hello!

I'm in a bit of a pickle. There is a form at my work that our clients fill out to request access to a meeting room. There is another form that I myself have to fill out after the client has used the space as a "report" of what happend in case there are any problems. The information from the first form needs to be exported and populated onto the second form. The second form has some extra fields on it for myself to fill in as the report side of it.

I have Excel and Access.

They are basically both the same form, just the field locations have changed and there are some extra fields at the bottom for myself to fill in.

What would be the best way of doing this?

Thanks in advance for any help receieved!
 

Answer:Exporting certain feilds from 1 Excel Workbook and importing into Another

I think that the easiest way to do this would be to import the other worksheet into excel. And then either link the worksheets together and bring the information that you need or if you need it to find things based on some other criteria then you use a vlookup to pull in the information that you need.
 

2 more replies
Relevance 54.53%

Can someone please tell me how to import tables from a web page into Excel 2000. I understand that a web query can be created, but when I attempt to reference the web page, the query won't run because the web page requires user authentication prior to access. Help!
 

Answer:RE: Exporting Web Page Tables into Excel 2000

You could possibly save the table and open it in word and copy it (Ctrl + C) and then go to Edit --> Paste Special in Excel and it should work. Or you could just copy it from the website and used the Paste Special in Excel.
 

1 more replies
Relevance 54.53%

I am a delegate of someones calendar and would like to export the contents into Excel. when I got to Import / Export im only seeing my local calendar in the list but not the shared. Can someone tell me how to export? thanks
 

Answer:Exporting a Shared Calendar into Excel using Outlook 2K3

ttt
 

1 more replies
Relevance 54.53%

So this seems like a very basic thing to do but I'm relatively new to VBA. Working in Office 2010.

I have a database that has customers names, years doing business with us, an other catagories to do with their credit/debit amounts. I also have a word document that I set some bookmarks up in the reference to them.

It would be nice to select a customers name, hit a command button and export the row of data associated with that customer to word. It would probably be best if the word document is already opened because the file location might change, or the document might change.

If anyone can guide me through this, that would be greatly appreciated.

Thanks
 

More replies
Relevance 54.53%

When I try to export Outlook Contacts to my P910i the Notes Section on each entry are cut short after typically 10 lines. Many of my notes are much longer. The info is visible within Contacts manager.For comparison I tried the following:1. Exporting to Excel does the same thing.2. Exporting to a txt file is fine, all info is there - Except column formating is wrong3.Exporting to Access looses the Notes altogetherAny Ideas why this should be how I can fix or get around it(I don't want to have to enter the notes directly as there are over 2500 of them !!)Thanks

More replies
Relevance 54.53%

I am trying to make an database of members for a racing organazation.

Each member has a word document which contains the membership form filled out with Word's Form feature. I know you can do Options > Save > Save Form data only, then save for each file, but i'd like to automate the process and save only form data for all of the documents at once.

Secondly, I'd like to import them into an excel spreadsheet. I've used the data import feature, but once again, the process has to be repeated for every single file. I cannot select more than one. Again, I'd like to autmate it. How?

Better yet would be a method to take all the .doc file's form data straight into excel without going to the middle .txt file.

Thanks for your help,
Doug
 

Answer:Exporting Word Form Data to Excel

14 more replies
Relevance 54.53%

I am using Outlook 2003 is there a way to export tasks to excel. I have copied task data from the public folder to a local folder. how can i export it into a excel list.

Answer:exporting task list from outlook to excel -vp

Outlook 2003 export tasks to excelhttp://www.google.com.au/search?hl=...http://www.microsoft.com/atwork/pro...http://office.microsoft.com/en-us/o...http://www.codeforexcelandoutlook.c...http://www.freeemailtutorials.com/m...http://www.outlookcode.com/article....

4 more replies
Relevance 54.53%

I recently upgraded QuickBooks. I had Basic 2004, Now have Pro 2005. When I go to Export a report to Excel (2003) the dialog box appears, but I only have the first choice "a comma separated values (.csv) file" selected.

The rest of the Basic Tab & all of the Advanced Tab is grayed out. I have no idea how to fix this.

QuickBooks won't tell me unless I sign up for their "Tech" support package. Rip-off!!!!

Can someone please help me??????

Thank you!!!!!
 

More replies
Relevance 54.53%

Is there a limit to the amount of nested Subqueries allowed in a SQL Statement? Here is my SQL Statement that DOES work, but uses a premade query:

Code:
SELECT FOL.MatType, FOL.Param, FOL.Material
FROM [B][Folder Listing Final][/B] AS FOL LEFT JOIN (

SELECT MT.Name AS MatType, MP.Name AS Param, M.Name AS Material
FROM (([Location-Product-Materials] AS LIM INNER JOIN Material_Parameters AS MP ON LIM.MaterialParam = MP.Material_Parameter_ID) INNER JOIN Materials AS M ON LIM.Material = M.Material_ID) INNER JOIN MaterialTypes AS MT ON MP.Type = MT.MaterialType_ID
WHERE (((LIM.Loc_Product)=9))

) AS ITM ON FOL.Param = ITM.Param
WHERE (((ITM.Param) Is Null));

UNION

SELECT MT.Name AS MatType, MP.Name AS Param, M.Name AS Material
FROM (([Location-Product-Materials] AS LIM INNER JOIN Material_Parameters AS MP ON LIM.MaterialParam = MP.Material_Parameter_ID) INNER JOIN Materials AS M ON LIM.Material = M.Material_ID) INNER JOIN MaterialTypes AS MT ON MP.Type = MT.MaterialType_ID
WHERE (((LIM.Loc_Product)=9));
When I replace the premade query "Folder Listing Final" with the SQL inside of it, I get a "Syntax Error in FROM Clause" message (but it does not tell me which from clause). This is the Code I Replaced it with, directly cut and pasted from the premade query "Folder Listing Final":

Code:
SELECT MT.Name AS MatType, MP.Name AS Param, M.Name AS Material
FROM MaterialTypes AS MT INNER JOIN (Material_Parameters AS MP INNER JOIN (([Locatio... Read more

More replies
Relevance 54.53%

Windows XP SP1
The problem is browser independent, affecting both IE6 and Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.13) Gecko/20060414
Firewall is ZA, Free version.
My ISP is Earthlink; DSL
The nominal Communications provider (after the copper loop) is COVAD.
The actual carrier appears to be Level3.

Web pages from "MAJOR" sites load promptly. Tracerout shows normal, prompt access to these pages.

Web pages from "minor" sites load only after repeated attempts, with many "www.website.com could not be found. Please check the name and try again" messages. Traceroute for these shows long paths, and delays along the way.

One possible work around might be to change the "timeout" on the page load so that the delay in access did not cause abort of the load, due to expiration of the timeout. (I am guessing about this, of course.)

What procedure should I use to increase the time the browsers give a page to return, before issuing a "page not found" error? (For Mozilla? For IE?)

What is my ISP and/or their service provider doing that is causing this difference in treatment of WWW pages, and making "minor" players on the internet unavailable?

Here are representative traceroute examples for "not found" sites:

Tracing route to pivonka.net [207.217.125.50]
over a maximum of 30 hops:

1 32 ms 29 ms 30 ms h-67-101-218-1.snfccasy.dynamic.covad.net [67.101.218.1]
2 29 ms 30 ms 29 ms 192.168.36.165
3 29 ms 23... Read more

More replies
Relevance 54.12%

I am using Access 97 to create a database for unusual incident reports at a child welfare agency. I am recording the date of the event, the start time, and the stop time, and am using a DateDiff formula to calculate the length of the event (i.e., if the the start time is 1:20 pm and the stop time is 1:30 pm, it returns a value of 10). However, I recently ran into a situation where an event started at 11:30 pm and ended at 12:15 am, and the formula returned a result of -1395. Now any person can see that the event was 45 minutes long and any educated person also knows that you cannot have a time span of negative minutes. Unfortunately, Access is neither and no matter what I do to tweak the formula and the format of the times (they are in medium time format, I tried changing to both short time and general date), it continues to give me a length of time of -1395 minutes. The formula I am using is:

Length: DateDiff("n",[Start_Time],[Stop_Time])

Does anyone have any suggestions on how to create a formula to calculate the length of time when an event starts on one day and stops on another? Also, it is very rare that an event spans two days like this, I've put in almost 200 reports and this is the first time I've encountered this, so I'd like to keep the data entry simple and avoid something like having to put in a start date and start time and a stop date and stop time for each report if possible. Any suggestions are appreciated. Thank you.

Greg
 

Answer:Calculating Length of Time in Access 97

Here's a thread from another forum that might give you a bit more insight about the way Access handles Date/Time calculations.

HTH

chris.

[edit]
Welcome to TSG, by the way.
[/edit]

[edit2]
Thought I might get a bit more knee-deep in your problem. How do you assign the [Start_Time] and [Stop_Time] values? If you're just typing in something like 11:30, then you're invariably going to have this problem. One way to resolve this is to add 24 to Stop_Time if Stop_Time < Start_Time (by the way, if the event lasted more than 24 hours this would be worthless). But when you start doing that you're not really dealing with a Date/Time data type anymore.

Admittedly I have very little experience with using Date/Time in Access, but I think you might be best off including the Start_Date and Stop_Date...or formatting the Start_Time/Stop_Time to include the date.

HTH more.
[/edit2]
 

1 more replies
Relevance 54.12%

Hi,

I have created a protected Word form, which comprises of text fields, drop down fields and tick boxes. I have an Excel spreadsheet with columns corresponding to most of the labels in my Word document.

Is there any way in which I can selectively export data from the Word form to the spreadsheet such that selected form fields data is exported to selected columns as row entries?

Hope my request makes sense.

Leegirl
 

More replies
Relevance 54.12%

Hi there,
I'm trying to export data from Word 2007 form fields into an Excel spreadsheet. I was hoping to have the spreadsheet contain data on a cumulative basis for the year or quarter at a minimum. Not sure how the code runs and if this is even possible. Does it scan a folder for all pertinent info to populate the spreadsheet?

Currently we are writing about ten of these docs a day and the data entry is becoming burdensome.
I have attached an example of the spreadsheet for reference.

I can provide specific examples of file paths or folder names if that becomes necessary.

Any assistance is greatly appreciated!

Thanks!
Cameron
 

Answer:Exporting Word form field data to Excel

Here's the word doc with form fields associated with the spreadsheet.

thanks!
Cameron
 

2 more replies
Relevance 54.12%

I am using MS XP Home Edition as OS and MS Office 2000.

I want to export the email IDs along with message content from all messages in a folder in MS Outlook to an excel sheet.

The option on 'Export' to an excel sheet is not working and requires installation from Office CD (which i tried but it fails to identify the Data1.msi file therein).

Is there any other way I can export the content using some other route or a freely downloadable utility.

I need to urgently export the mails as i need the message sender's ID and the message content as data.
 

More replies
Relevance 54.12%

i am facing problems while updating the records from Excel File.the excel file contains all values.but when tried to bs a source it is generating errors as nulls
 

More replies
Relevance 54.12%

Need to setup a process of importing vendor/company/bills using Excel and files in the IIF format to bring data into Quickbooks and then take that over to my Wachovia Online Account to cut checks. Anyone have experience using QB and the importing and exporting back from online banking thru to QB and then back to my back office?
 

Answer:Quickbooks importing and exporting Excel and IIF format files

It's been a long time since I've done this, but I believe the last time I did importing into QB, I found the best way was to Export a file first to give me a template to work with.

Just thought I'd mention it to give you an idea.
 

1 more replies
Relevance 54.12%

Hi Guys -

We are exporting "Coverage Reports" some lengthy, some just a few pages, and for some reason when off location the reports we export into Adobe PDF are taking much longer than the Excel format reports. We have the option to choose which format we want to export to depending on the customer needs.

Does anyone have any clue what may be causing the Adobe PDF's to take so much longer? I checked the file sizes and the Adobe PDF's are actually smalled in size than the excel spreadsheets!

Any thoughts would help! Let me know what details I can provide that may help! We are primarily using IE.

Answer:Help! Exporting Reports to PDF taking SO LONG (Excel Fine!)

Are you using the 'Print to PDF' option from the printer dialog when saving the reports?

Could always try a different PDF printer:
CutePDF - free for commercial use

1 more replies
Relevance 54.12%

Hi Everyone!

I have a form that I created in Word 2003 (see attached). There are a few things that I’d like to accomplish with this form.

1) once the form is completed by the user, I want to be able to export the entered data into an excel spreadsheet (via macro button – submit/export - and VBA for the actual transfer of data?)
2) for 3 of the sections with radio boxes (employment type, rate your experience, and the 1st line of availability (1 shift/wk, 2shift/wk…)) I would like only one selection to be made. So the user can only select one of the options, and not multiple. Actually the Teaching Experience one…I need it so they can select whichever grades they teach, but only one selection of ‘years taught’. They can select any/all the MPMxx but it’s the ‘years’ that is important…

I have a very basic understanding of VBA but I work with excel all the time so I’m relatively comfortable with some things and willing to learn/try new things…

Can someone please point me in the right direction as to how I can accomplish this?

What I envision is the form being completed then sent back to me. I then hit a button embedded in the form that will then export the data to my excel spreadsheet where I can sort, etc…

Any help would be much, much appreciated as I’ve tasked myself with completing this…when maybe perhaps I should have tried to figure out how complicated this might be first…

Thanks for reading!!!
 

Answer:[VBA] Exporting Word 2003 Form Data to Excel

Files
http://www.mediafire.com/?xxexol8mexwi1ma

Okie, my objective here is to transfer the data from a word .doc into an excel spreadsheet. The form is all bookmarked with proper tags. I have started the VBA code, but I’m at a loss as to why some things aren’t working…


Sub Report1()
Dim path As String
Dim wdApp As Word.Application
Dim wdDoc As String
Dim curDoc As Word.Document
Set wdApp = CreateObject("Word.application")
wdApp.Visible = True
path = "C:\Users\xxxxxx\Documents\APPLICATION FORM\FINAL COPIES"
'Get first document in directory
wdDoc = Dir(path & "\*.doc")
'Loop until we don't have anymore documents in the directory
Do While wdDoc <> ""
'Open the document
Set curDoc = wdApp.Documents.Open(path & "\" & wdDoc)
Range("A1").Select
Selection.End(xlDown).Select

ActiveCell.Offset(0, 1).Value = curDoc.FormFields("DATE").Result
ActiveCell.Offset(0, 2).Value = curDoc.FormFields("FNAME").Result
ActiveCell.Offset(0, 3).Value = curDoc.FormFields("LNAME").Result
ActiveCell.Offset(0, 4).Value = curDoc.FormFields("EMAIL").Result
ActiveCell.Offset(0, 5).Value = curDoc.FormFields("OCT").Result
With ActiveCell.Offset(0, 6).Value
If FieldName = True Then
ActiveCell.Value = "PERMFT"
ElseIf FieldName1 = True Then
ActiveCell.Value = "LTOS"
ElseIf FieldName2 = True Then
ActiveCell.Value = "RET"
ElseIf Fie... Read more

2 more replies
Relevance 54.12%

I am trying to make a database based on survey data collected in Microsoft Office Forms.

Each subject has submitted a word document which contains responses to survey questions filled out with Word's Form feature. I would like to automatically populate an Excel spreadsheet with the form fields from a large group (25-50 documents per batch).

I have seen questions similar to this raised in other forum posts, but I seem to be running into problems with the suggested macros. This might be because I am working on a Mac (the only computer at our company) in Microsoft Office 2011. Any suggestions?

Thanks for your help,
Sasha
 

Answer:Exporting Microsoft Word Form Data to Excel

Hi Sasha
If you are wanting to use VBA to copy / move between Word and Excel you will almost certainly need appropriate boxes ticked under references in the VBA editor for Microsoft Excel XX Object Library.
I've no idea whether the Mac version is set up the same and would imagine you would have a bit of work to do to translate VBA written for windows into a mac variant.
What you might do is consider providing some dummy data and files and seeing what we can do to help.
 

1 more replies
Relevance 54.12%

Hello,

Relating to a previous post:
"Exporting Word Form Data to Excel"
http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html
regarding the same form in many word docs esported into an excel sheet

My question is whether its possible to export repeated forms in ONE word doc so they collate into 5 columns.
(Would like the first 2 columns and 2 rows left empty )

My form look in word is thus:

Story:
Image: 01
Display-image:
Courtesy:
Caption:

Story:
Image: 02
Display-image:
Courtesy:
Caption:

Story:
Image: 03
Display-image:
Courtesy:
Caption:

etc

Sample.doc is below

This macro obtained from:
"Solved: Export Word Form to Excel"
http://forums.techguy.org/business-applications/1062655-solved-export-word-form-excel.html
works well for the same form in many word docs exported to excel:
Code:

Dim vField As FormField
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer

Sub AddFormFields()

If ActiveSheet.UsedRange.Count = 1 Then
vLastRow = 1
Else
vLastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
End If
vColumn = 1

Set fso = New Scripting.FileSystemObject

Set fsDir = fso.GetFolder _
("C:\Documents and Settings\User\Desktop\CIKA 2004\Members\UnProcessed")

Set wdApp = New Word.Application
wdAp... Read more

Answer:Solved: Exporting Repeated Forms In One Word doc To Excel

12 more replies
Relevance 53.71%

In Access 97 I could export an Access report to a tab-delimited text file. In Office XP Access 2000/2001, I get an error message: "Invalid procedure call or argument." So I'm having to export to Excel, then from Excel worksheet to a text file. Is there an easier way to do this, and what the heck is a procedure call? Thanks for any help.
 

Answer:Exporting from Access

I hove Office XP. I don't have a database set up with a report but I tried to export a table and I can export it in .txt file format, excel format and many other formats.

Maybe you should try to export the table that the report was created from.

If this doesn't work maybe you need to run the detect and repair to make sure it is set up correctly
 

2 more replies
Relevance 53.71%
Question: Exporting Access

Can a Microsoft Access Data Base table be opened by Microsoft Excel?

Answer:Exporting Access

Yes, just open the Access table in Excel.

1 more replies
Relevance 53.71%

I am trying to parse a field that contains the dimension of packages into it separate components. The field is a text field with the length, width & height separated by ?x??s.

The issue is that the dimensions are not all the same number of characters. For example. One record may be 2.5x1.8333333x1.75 and another 1.66666667x0.75x1.

What I?m trying to do is pull the string up to the first ?x? as the length, between the ?x??s as width and after the last ?x? as the height.

Any ideas would be appreciated.

thanks in advance
Rick
 

More replies
Relevance 53.71%

Hi, i am noob in excel, i made an excel which fetch data from a stock market site which auto refresh at specific time interval, i want to auto export some specific data of excel in text format to my hard disk, i want to import new refreshed data in same file,document without deleting previous data.In my excel, time and date auto updates.
attached the excel, i want to export the data in range of c33,c34 to i 33,34
 

Answer:Solved: auto exporting excel data in plain txt format

13 more replies
Relevance 53.71%

Running WinXP and Office 2003

Hello. This is similar to http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html

I tried using and tweaking that example but am having a hard time because there are several different things.

I will be having hundreds of word documents. The first page on each doc is just a form that a user fills out on the computer. I would like some help with the macro that would run and process a folder of these docs.

I would also like to have 3 sheets in the one excel file. The doc file will be filled out generally by 3 departments. Is there a way to have a drop menu in the doc to indicate which dept and also have this transfer to their respective sheets in the excel file? The rest of the doc fields should be the same. Also I need the hyperlink to the file in their respective cell.

Sorry I am new to code in excel and am starting to learn its power. Thanks for your help!
 

Answer:Solved: Exporting Word Form Data to Excel Spreadsheet

16 more replies
Relevance 53.71%

Hi folks, not sure if this is possible or not but I'll try to explain what I'd like to do.

On the first sheet, I have a simple sheet to be filled in daily. The date is changed, and then daily pick figures and hours picked are updated by the relevant department.

I then have to manually put all of the data into the second sheet, which acts as a log of previous pick figures.

Is there a way the second sheet can automatically be filled in when the date is changed and new figures are put into sheet 1?

I hope I've explained this well enough, I'm trying to teach myself excel as I'm going along! Thanks.

Edit - I've had to delete peoples names' for obvious reasons, initials in sheet 2 will correspond to people in sheet 1.
 

More replies
Relevance 53.71%

I have a Microsoft word mail merge with around 11 fields, I wish to export 2 specific fields into an excel spreadsheet, is this possible and how would I go about doing this?
I use Windows 7, Microsoft Word 2007 and Microsoft Excel 2007
Please assume I have very basic skills in relation to these programes, so may need to be spoon fed a lot of the information

Thanks in advance,
Thomas
 

Answer:Exporting specific field from word mail merge to excel

9 more replies
Relevance 52.89%

I'm a novice Access/database user with probably a novice problem. I am trying to export from Access to dBASE. I have followed the instructions for exporting data, searched the help function, the archives in this forum, and my books on Access and have not found the answer to my problem. When I try to save the query to a dBase file, I get a message that reads "field will not fit in record" I have the fields set up in the Access table exactly as the dBase user (my boss) described them. I have checked the fields in each record to see if the data is the correct size. The largest field is 34 and that is how my boss has it set up in his dBase tables. I have no idea how to proceed, and hope someone can help me. Thank you,
 

Answer:Exporting to dBase from Access

13 more replies
Relevance 52.89%

I created a database that runs 6 separate macros, and those macros are 2 different platforms. Platform A runs first creates a folder with the yyyymm then yyyymmdd and then within that there is a table that exports into it as excel. The Platform A folder creation and export are both RunCode options in a macro. I am trying to get platform B to export into that made folder, however I cannot get the code or a macro to complete with the process. This is the code I use to get the export to work when I am within the module, however this code does not work as RunCode in the macro because the folder is already created. I don't want to create an additional folder so I put the ' in front so it wouldn't create a folder, but I thought it would help for it to know where to go.

Public Function Export()
strRoot = "\\folder\folder\folder\folder\Folder\Fallout\Export\"
strMonth = Format(Date, "YYYYMM") & "\"
strDay = Format(Date, "YYYYMMDD") & "\"
strPath = strRoot & strMonth & strDay

DoCmd.TransferSpreadsheet acExport, , "table_export", strPath & "LS Fallout_" & Format(Date, "YYYYMMDD") & ".xlsx", True

Is there a wild card I can use for it to find the folder? I tried adding Currentproject.Path\export\*yyyymm* & Format(Date, "YYYYMMDD") & ".xlsx" within the macro and that doesn't work either.

Thanks
 

Answer:Access 2010 exporting

16 more replies
Relevance 52.89%

Hi,
I have a 5 or 6 page access report that I need to export to a .txt file.
I have 2 problems:
1. I get extra spaces and sometimes data dropout near the page breaks.
2. I can't get the report footer to follow the rest of the data. It prints on its own page.
This gives a big space before the footer and messes with the data as well.
I have changed all text boxes to .125 as per ms.

I have spent 300 hrs on this package. This is all to be done, its driving me nuts.

The goal is to just get a clean export of all the text in the report into a .txt file.

Thanks
Access 2003, XP pro
 

Answer:Exporting Access Report to .txt

8 more replies
Relevance 52.89%

I am using Office 2007, and I need to export an Access table to an XML file, and I need all fields, even the null fields to be included in the export file. When I export the table, only the "not-null" fields are included in the export.

I have a vendor that needs my data today. Can anyone help me?
 

More replies
Relevance 52.89%

Hi,
I've been searching all kinds of fora for this problem and although I find information on how to do this with (legacy) Form Fields, my problem involves Content Control fields and I can't seem to fix this.
Basically I have Sales Reports that are being filled out on a weekly basis by all Sales Reps. These contains all kinds of different Content Control fields (Drop down, rich text, dates etc...), and the data in there should be copied to an excel sheet. Meaning: copying the contents of the fields from all the different reports into 1 excel report.
Below is a Macro I found which works for legacy forms (FieldForm) (pre-2007) but I cannot seem to make it work for 2010. I pinned down the problem to being just a wording problem in MS, but then again, it might be a little more complicated

Many thanks for your help,
Code:

Dim vField As FormFields
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer
Sub AddFormFields()
vLastRow = ActiveSheet.UsedRange.Rows.Count + 1
vColumn = 1
Set fso = New Scripting.FileSystemObject
Set fsDir = fso.GetFolder _
("Q:\Sales Reports\Unprocessed")
Set wdApp = New Word.Application
wdApp.Visible = True
For Each fsFile In fsDir.Files
wdApp.Documents.Open (fsFile)
Set myDoc = wdApp.ActiveDocument
For Each vField In wdApp.Documents(myDoc).FormFields
vField.Select
vV... Read more

Answer:Exporting data from Content Control Fields in Word to Excel 2010

6 more replies
Relevance 52.48%

Again, I have to tap the vast knowledge of the users. I would like to export my personnel database to a preexisting excel spreadsheet. In the spreadsheet there are a number of tabs for the various departments in our organization. I think that I will be able to export it ok, but is there a way to export to different tabs in the spreadsheet based on a selection (dropdown) in the database? Thanks for all your help.

-Josh
 

Answer:Solved: Exporting Access to Excell Help

16 more replies
Relevance 52.48%

Office XP:

To bring down the size of our database we have made a copy of the databsed (Called Archive) then in the live database we have deleted the older records.
Even though we have only deleted records that are "Closed" before the end of 2007, occasionally one of these will become Live again.

I know that I could open the the table in both the archive and the live database and copy and paste the record over but I would not like to show my colleagues this method (we would end up without a database ).

Ideally, I would like them to be able to bring up the record using the normal form in the archive database, click a button and it would export the current record over to the live database.

As the archive is just a copy of the live database before we deleted the records there would be no problem with field names etc.
Any advise.

Thanks
SBF
 

More replies
Relevance 52.48%

I need to export an access report into a tab delimited txt file so that I can upload it into another program (QuickBooks). I've created the report in access so that the formatting looks just right. However when I export as (txt, csv or tab) it creates a file that has spaces between the fields and not tabs, and that screws up my upload.

How do I get the tabs as delimiters?
 

Answer:Exporting Access Report to .tab file

10 more replies
Relevance 51.66%

Can someone advise on the following please ?

I developed a system for remote offices which do not have access to network drives.
I visited all these offices, and installed the mdb on their C drives.

Each month, they all export 5 tables, and email them to their boss here in Head Office, who then imports them into his own mdb.
He will then be able to run various queries and reports against all this data.

This works fine.

Eventually the remote offices will also be required to run queries and reports.

I have my own copy of the mdb, and have developed the necessary queries and reports, which will shortly be ready for installation.

My question is this :
How can I transfer any queries and reports from my mdb to those of others ?

I would have thought I could do this by exporting and importing, but this does not seem to work.

If I try to export a Report, what I get is the output from the Report, not the Source, which is what I need.

Or is this the wrong approach entirely ?

I have tried Googling the problem, and have seen something about Application.SaveAsText, which is an addon, but I don't have the necessary privileges to install this, and it would contravene corporate policy anyway should I attempt to.

Surely there has to be a simple way in MS Access to transfer Queries and Reports to and from mdbs !
 

Answer:Solved: MS ACCESS 93 : Exporting Queries & Reports

Hello, yes you take a copy of the Current database with the new queries and reports and paste it on the other computers that have the original databases.
Open the original database (without the queries & reports) and File>Get External Data>Import browse to and open the new database, select the queries and reports you want to import and when you have slected all you need click OK.

PS, you tend to get a quicker response to Access & Excel questions on the Business Applications Forum.
 

2 more replies
Relevance 51.66%

Hi ,

I want to export the pivot table from Access to excel. I know the option of exporting with data. But i want to export only the pivot table without the source data. Can you please tell me if there is any option available in Access.
 

Answer:Solved: Exporting Pivot table from Access

HI all,

I am still waiting for the solution for this issue.
 

1 more replies
Relevance 51.66%

I've looked around the net, but haven't been able to find a decent answer.. Can anyone tell me if its possible to export a single record in form view as an image? either jpg or pdf..

I've got a database that has text placed over the top of a background image and would like to be able to save/export different records including all their data as an image file.

Im using Access 2003.
 

Answer:Exporting an Access record (form) to an image

In one word NO! not automagically
But you can use a photo editing tool to take screen shots or snapshots & use them
 

3 more replies
Relevance 51.66%

I have a db in Access 2010 and I'm trying to export the results of a SELECT query to an Excel file. I'm saving the export because I eventually want users to be able to run the export through a macro.
When I run the export everything seems to work fine the first time. But, after that I get an error "Query must have at least one destination field."
Then, when I open the query in Design View all tables and fields have been cleared out In SQL View it just shows: "SELECT;"

So, I open another copy of the backed up db, try again...same thing. After trying 4 times and having the same thing happen, I turned to google to try to figure out what's causing this. But I can't find anything remotely close and don't really know what to search for!

Any help would be greatly appreciated!
 

Answer:Access Select Query is cleared out after exporting

Are you saving the query before running it?
 

8 more replies
Relevance 51.25%

I've searched the forums for a resolution to this problem, the closest thing I could find was this post.

I want to archive my emails. My email server (campus email) used to support SMTP access, so I could get my mail directly through MS Outlook 2000. However, the admin disabled all SMTP access in favor of OWA. However, I can't seem to find a way to download, say, a particular folder, or a selection of emails, even to text files without saving each email individually per the linked thread.

Is there any way to do this? I noticed that most of the OWA threads were left unresponded...

Thanks for any tips,

chris.

[edit]
It happened a couple years ago, and at time of posting I seemed to remember it being an SMTP issue, but that didn't make much sense so it must've been a POP issue...but it was one or the other.
[/edit]
 

Answer:Solved: Downloading/exporting folders using Outlook Web Access

[bump]

Mods, is this thread in the wrong forum? Like I said, most of the OWA threads in Web & Email have 0 responses. If so, could you please move this thread to a forum that might be more able to address this issue?

Thanks,

chris.
 

3 more replies
Relevance 51.25%

Just installed office 365 (Access 2013). DB created in 2010 seem to be working (haven't tested it all yet) Right now this code:

DoCmd.OpenQuery strQueryName, acViewPivotTable, acEdit
DoCmd.RunCommand AcCommand.acCmdPivotTableExportToExcel

Is producing this error 2046

The command or action 'acCmdPivotTableExportToExcel' isn't available now.

I have made the db location a 'trusted site' and enabled macros results are the same. MS website indicates .acCmdPivotTableExportToExcel is a valid but it doesn't appear in IntelliSense. Is this not available? Is there a different way to export a query as a pivot table?
 

Answer:Solved: 2013 Access not exporting Pivot table

Have you set the various VBA Editor Library References?
You could try "Linking" to the Query or even copying and pasting it.
 

2 more replies
Relevance 50.84%

Hi, I have a query that is being exported to XML. Everything works, except for expressions in the query such as:

[Forms]![find projects]![Find Projects Subform].[Form]![Budget]

When the query is just opened normally, the expression works but when the query is being exported to xml I am asked to specify the value for that expression even though the form is filled in with a value already. What do I need to change for this to work? Thanks!
 

Answer:Solved: Access 2003, extracting form contents while exporting to xml

I solved the problem myself by directly implementing the query the dynamic field utilizes
 

1 more replies
Relevance 50.02%

Hey everybody

A report that I have in access messes up when I export it as an Excel spreadsheet. I export it, and then go to open the excel file. When I open the file up, I get the error message "File error. Some formats may have been lost."

When this happens, I look at the excel file, and the some of the dates I have are numbers like "38848". The dates should be dates like 5/25/2006.

The odd thing is, all the dates aren't messed up. Any ideas on what is going on?
 

Answer:Solved: Access 2003 - Exporting Report to Flash causes Formatting loss

Hey smooth, for an explanation of the dates turning into numbers, check my signature (Access Dates and Access Date Conversions both have info). I don't know why it would happen with only some, but there must be a common trait among the dates that get swapped.

chris.
 

3 more replies
Relevance 48.79%

I need to export data from an excel spreadsheet to be used by another program. This other program needs to the see the data in a .txt file that is comma delimited ascii. The values (or data in each cell) must have quotes around them to work in this other program, but I cannot figure out how to get quotes around the values when saving into .csv or other comma delimited formats. I only get data separated by commas.

Any help?
 

Answer:Solved: exporting excel data into comma delimited ascii with "quotes"

6 more replies
Relevance 45.92%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
DrawingNumber
ItemNumber
Quantity
PgeCode
Description
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
Stop
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
Loop
End Sub
Sub GetData(fl)
Stop
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...
Code:

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
Loop
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Loop
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 44.69%

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

Answer:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

1 more replies
Relevance 44.28%

Hi

I need to add rows from Access table to Excel spreadsheet by using VBA.

I cannot create a new file for various reasons, so I cannot use command “TransferSpreadsheet”.

Is it possible to do it?

Thanks
 

Answer:Solved: Access 2003. How to add rows from Access table to Excel spreadsheet by using

16 more replies
Relevance 43.87%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!
 

Answer:Access 2010 Help Merging 4 Excel Files into One Access Database

9 more replies