Microsoft Access Forums - Import/Export Datahttp://www.accessforums.net/
Using or generating external data.enFri, 18 Aug 2017 02:19:28 GMTvBulletin60http://www.accessforums.net/images/misc/rss.pngMicrosoft Access Forums - Import/Export Datahttp://www.accessforums.net/
Importing via VBA from Excel Spreadsheet into MS Access 2013http://www.accessforums.net/showthread.php?t=67608&goto=newpost
Thu, 17 Aug 2017 20:49:04 GMTWhen attempting to import an Excel 2013 spreadsheet with an approximate size of 2,315 KB after running for a while, it will eventually crash with an...When attempting to import an Excel 2013 spreadsheet with an approximate size of 2,315 KB after running for a while, it will eventually crash with an 3183 error with a message about running out of temporary disk space.
Any suggestions on how to fix this?

Any advice is appreciated.

C Dixon
]]>Import/Export Datacdixon102419607http://www.accessforums.net/showthread.php?t=67608Exporting with formattinghttp://www.accessforums.net/showthread.php?t=67592&goto=newpost
Wed, 16 Aug 2017 21:33:29 GMTHi- I am trying to export about 100 queries from an access database into various excel files. EAch excel file has three queries, and each query must...Hi- I am trying to export about 100 queries from an access database into various excel files. EAch excel file has three queries, and each query must be exported into one tab. So there are 3 tabs per file and each tab corresponds to a query. I'm exporting thru an access macro. I would like to export the formatting from access into my excel file, however, the excel export is very crude- not at all what I see in access. I tried the "export with formatting" option and it works for one tab per file...i am not skilled with vba, and neither is my colleague. is there a way to export with formatting given my parameters above?
]]>Import/Export DataSjb185http://www.accessforums.net/showthread.php?t=67592Importing Data in an Excel file on Sharepointhttp://www.accessforums.net/showthread.php?t=67579&goto=newpost
Wed, 16 Aug 2017 14:35:40 GMTHi,
I am trying to import an excel file located on a sharepoint site to a table in my database. All I can seem to do is import the list structure...Hi,

I am trying to import an excel file located on a sharepoint site to a table in my database. All I can seem to do is import the list structure then drill into a hyperlink in that list structure and it opens the file in excel.

Is there not a way to import the data in that spreadsheet into a table as if you were importing it from your desktop?

I must be missing something

Thanks
]]>Import/Export Datamindbenderhttp://www.accessforums.net/showthread.php?t=67579Link between Excel and Accesshttp://www.accessforums.net/showthread.php?t=67418&goto=newpost
Fri, 04 Aug 2017 20:55:12 GMTI am trying to import a table from my existing ms access database to ms excel. When I click on Get External Data, From Access, I get a dialog box...I am trying to import a table from my existing ms access database to ms excel. When I click on Get External Data, From Access, I get a dialog box that tells me about data link properties. I click on "Test Connection" and it get another dialog box showing a failure. See attached files.

I try to set up a valid link (which I had before) to import a table from my database, but I am running into trouble. Can anyone help?

]]>Import/Export Dataclrockwell15http://www.accessforums.net/showthread.php?t=67418http://www.accessforums.net/showthread.php?t=67366&goto=newpost
Wed, 02 Aug 2017 18:42:18 GMTHi
I am using a vba code to import excel file to ms access. As per the requirement i need to generate a log file for the successful/failure of the...Hi

I am using a vba code to import excel file to ms access. As per the requirement i need to generate a log file for the successful/failure of the import. I am not sure how to do this any help will be appreciated.

MsgBox "File Not Found.Check File name or location."
End If
Dim SQLDelete As String
SQLDelete = "Delete * From TempFromExcel"
DoCmd.RunSQL SQLDelete
DoCmd.SetWarnings off

End Sub
Function FileExist(sTestFile As String) As Boolean
Dim lSize As Long
On Error Resume Next
'Present lenght to -1 because file length can be zero
lSize = -1
'Get the length of the file
lSize = FileLen(sTestFile)
If lSize > -1 Then
FileExist = True
Else
End If
End Function
]]>Import/Export Datasubhasmitahttp://www.accessforums.net/showthread.php?t=67366http://www.accessforums.net/showthread.php?t=67335&goto=newpost
Tue, 01 Aug 2017 00:50:40 GMTHello
When trying to connect to MySQL database using the connection wizard, the option for MySQL is not even there. Any ideas why SQL is by MySQL...Hello

When trying to connect to MySQL database using the connection wizard, the option for MySQL is not even there. Any ideas why SQL is by MySQL is not?

Hello All.
I have a saved query called "Query1" which has one parameter of type Short called "ID." I would like to set the parameter within VBA before the query is exported to an excel file. Eventually I will let the user select or type the value on the form, but for the purposes of this question I am setting the value explicitly within the code.

My problem is after the save dialogue box opens for the excel file, Access is still asking for the value for the parameter even though once I get down to line 8 in testing, the Immediate Window shows me that qdfExport.Parameters(0).Name is ID and qdfExport.Parameters(0).Value is 5.

Everything I have found online has given me a similar code layout to what you see here, and I have tried all of the similar combinations of code to this one with the same results. Is there any way of setting the parameter to a query within VBA so that the user is not prompted to enter a value before saving the excel file.

Thanks
]]>Import/Export DataRedNumberhttp://www.accessforums.net/showthread.php?t=67306Import Excel From Different Computers/Networkshttp://www.accessforums.net/showthread.php?t=67280&goto=newpost
Fri, 28 Jul 2017 07:52:11 GMTHi,
I had an interview and they sent me a project. I did the project but it requires imported into MS Access which isnt a big deal and ive been...Hi,

I had an interview and they sent me a project. I did the project but it requires imported into MS Access which isnt a big deal and ive been able to automate it from my computer(s) thru vba. But when I send the project in, the save imports will be useless because their computers will have diffect file paths, how can i work around this?

I'd like to import text files into a field in Access 2016. I have a database in which I have the path name that refers to folder and a text file within the folder in each record. Each text file is extracted, raw OCR text, not delimited text. Each text file is associated in each record with an image or with a multi-page PDF from which the OCR text file was obtained. I have on each record a browser control that displays the image or PDFs. At present, I can view the text files using the text path field (see image) to display the text (also using browser control), but the viewable text is not searchable. I want to use the filepath field in each record to import the text--not to just refer to the separate text files, because I need to be able to word-search across the entire population of OCR records to find records related to searches.

How do I accomplish this? Is this a transfer text command? Or something else? Any help would be great!

]]>Import/Export DataDoug Simpsonhttp://www.accessforums.net/showthread.php?t=67259Import From Excelhttp://www.accessforums.net/showthread.php?t=67250&goto=newpost
Thu, 27 Jul 2017 07:24:05 GMTHello guys,
I am trying to automate a procedure on Ms Access where we used to copy paste data manually on Access. I added a button that will do...Hello guys,

I am trying to automate a procedure on Ms Access where we used to copy paste data manually on Access. I added a button that will do this job automatically and insert the data in its specific table. Anyway I imported the Excel spread sheet into a Temp table and reinserted the data in Temp in the corresponding table. The insert was done properly, yet the access database I am using has some queries related to it and once I refresh those queries, different results occurs then the ones I get when I upload the data manually by Copy/ Paste from Excel

I am using Office 2013

Any advice on the issue?
]]>Import/Export DataYehiaHhttp://www.accessforums.net/showthread.php?t=67250http://www.accessforums.net/showthread.php?t=67245&goto=newpost
Wed, 26 Jul 2017 20:30:54 GMTHello everyone,
I am very new to MS Access, So please help me in this.
I need to import a excel file to MS Access database , where the excel...Hello everyone,

I am very new to MS Access, So please help me in this.

I need to import a excel file to MS Access database , where the excel file will be refreshed everyday and i need to get the updated data everyday how can i do this.

I used the DoCmd.TransferSpreadsheet method but it is not updating the table in MS Access
]]>Import/Export Datasubhasmitahttp://www.accessforums.net/showthread.php?t=67245http://www.accessforums.net/showthread.php?t=67182&goto=newpost
Fri, 21 Jul 2017 16:06:24 GMTI have table relationships between two different Excel import files, which are now tables within the Access database through a Form code I created...I have table relationships between two different Excel import files, which are now tables within the Access database through a Form code I created that can browse and import Excel files automatically into Access Tables.

What I am wanting to do however, is be able to save a new version of each of these two Excel import files that overwrite the previous two into my database once a week that will automatically contain the table relationships - is this possible?

Or, is there a way to VBA code and save a relationship instruction, so that if I delete the two files once they are a week old for example, then import the two newer versions with exactly the same file names, that code could then perform a new relationship which is identical to the the last relationship between those two tables?I'm just aware that when I delete one or both of the tables, the relationships obviously break, then when I import the newer files, obviously at the moment I'm required to create new table relationships.Hope the above makes sense, and any help would be appreciated massively.