Uploading Problem

Oct 25, 2006

Colm,

I can't seem to upload on this site anymore (I could do it a few days ago). Is there a problem with the uploading or am I doing something wrong? It looks like my uploading capabilities are off. Can I please have uploading capabilities?

I have some sample code I'd like to upload to answer a few threads.

View Replies


ADVERTISEMENT

Uploading Data.

Jun 21, 2007

I have created my database - I now need to upload data from my old database.I have the old data in an excel spreadsheet and have edited the data so that it matches the coloums in the new database.I have one problem,I can upload all the person data into the person tableand I can upload all the organisation data in the organisation table(I'm assuming I just copy and paste it into the tables in the new database.)BUT and this is a big BUT.. the employment table is the linking table where you select an organisation from the drop downlist and you select a person from the person dropdown list, you add other details about emplyment and save the record.Does this mean I will have to do this manually, i.e create all the links manually??And is my cut and paste method above corect??Thanks is advanceEdit: I have attached the database to help you understand

View 1 Replies View Related

Uploading Data.

Jul 2, 2007

You must have creted databases before which needed to be populated with dada from another source.I have a database with three tables.PeopleOrganisationsEmploymentI have two spreadsheets - one with organisations and one with people.Approximately 700 records for each - how will I upload these and more importantly will I have to manually make the links in the linking table(emplyment??)Please adviseThe database is attached to help

View 1 Replies View Related

Uploading PDf File

Jan 23, 2008

Hi there,

My user want to upload the PDF files to the access database using the access forms. First of all is it possible? If yes then how can i do this?

Thanks alot
Danny

View 3 Replies View Related

Uploading An Access Table Into SQL

Feb 21, 2008

I want to push a table from Access to a specific SQL Server database.

Is there an easy way to do this? I have an ODBC connection to the SQL Server Database and I can import tables from SS to Access... but is there a way to do the reverse?

Thanks much!
Gary

View 2 Replies View Related

Uploading Image Name To Database

Jan 29, 2006

Hi

I am trying to simply upload an image to a image folder then take that image name and put it into a access database for retravel at a later date???

I can not work out why I am getting the following error and am going cross eyed with it ... can anyone see where I have gone wrong??

The error:

Persits.Upload.1 error '800a0018'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/UploadScript1.asp, line 26

The line of code:
Code:File.ToDatabase connection, SQLsmt

The whole code:
Code:<%dim MyConnSet Upload = Server.CreateObject("Persits.Upload")Upload.OverwriteFiles = False ' Generate unique names Upload.SetMaxSize 1048576 ' Truncate files above 1MB Upload.SaveVirtual "/images" ' Save to data directory Set File = Upload.Files("THEFILE") set connection=Server.CreateObject("ADODB.Connection") Connection.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:inetpubftprootlocalusericlay
emember ing.co.nzdb
emembering.mdb;" If Not File Is Nothing Then set connection=Server.CreateObject("ADODB.Connection") Connection.Open="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:inetpubftprootlocalusericlay
emember ing.co.nzdb
emembering.mdb;" SQLStmt = "SELECT * FROM memorial WHERE remid = '"&setremid&"%'" SQLStmt = "INSERT INTO memorial.mainimage VALUES('"& thefile &"')" 'response.Write(SQLstmt) 'response.End File.ToDatabase connection, SQLsmt Response.Redirect ("tribute2.asp?REMID=") & intremID Else Response.Write "File not selected."End If%>

View 10 Replies View Related

Uploading Forms To Central Database

Jun 14, 2006

Hi there,

I have a problem and wander if anyone knows a solution?

I have a central database that runs on a stand alone machine (soon to run on a server with VPN connection), it has a form that enables us to report faults this works fine however i would like to be able to send the form out to our operators (all over the world) for them to fill in when needed. then what we would like is for them to send it back to usand then for us to upload it to the central database.

is this possible or is there any other option?


Thanx tom

View 1 Replies View Related

Uploading Multiple Pictures Into Access

Oct 18, 2006

Hi there
im trying to build a database that stores a large number of photos and would like some suggestions on how i can upload multiple photos (20+) at one time without uploading each one individualy, preferably through a form.

To outline the problem, each member of the team has a camera that they take to jobs, when they return i want them to be able to open a new form, enter the job number (the primary key) onto the form and then somehow drag and drop the pictures from the camera onto the form to upload them.

Is this possible through Access? is this the best way of uploading multiple photos easily? and how do i build this?

Thanks in advance
MJ

View 2 Replies View Related

General :: Uploading Pictures To Access?

Mar 22, 2013

I am currently working on a project for work on re-creating our database for our daily audits. We enter daily information on a form which feeds to the table and in return we run the queries to get the percentages and all that good information. I was asked to be able to load a picture of to a particular record. Can I do that from the form and that link to the table and to the queries that run?

View 2 Replies View Related

Reports :: Form For Uploading Page Headers

Aug 6, 2015

I built a form that will allow each page header to take the info needed depending on who is using the data base. I seem to be having a problem having the Logo uploaded so that it can be used. Since I am new to Access, my only example would be like a web page. use the location of the picture in the code and it pulls it up for each page associated. I guess this would be 2 questions. How do I add to my form the upload of the graphics and how do I get the reports and forms to pull that picture into the header every time.

View 4 Replies View Related

Modules & VBA :: Automate Process Of Uploading Inventory

Jan 3, 2014

I have a large database of items we sell on Amazon, I am looking to automate the process of uploading the inventory.

I am uploading a tab delimeted text file using the following code,

With CreateObject("msxml2.xmlhttp")
.Open "POST", strURL, False
.setRequestHeader "Host:", "mws.amazonservices.co.uk"
.setRequestHeader "User-Agent:", "VBA"
.setRequestHeader "Content-MD5:", md5hdr2
.setRequestHeader "Content-Type:", "text"
.send c2a
Forms!Form1.Text3.value = .responseText
End With

I am confident I have the signature and the MD5 Header, but I cannot get the data into Amazon!

I keep getting a non-descript error "InputDataError".

When debugging my Play API, I was told that the "send" command was not uploading the file contents, it was uploading the filename! So c2a is a string variable that contains the tab delimited data. This works like a charm for Play, but no joy for Amazon.

View 4 Replies View Related

General :: Uploading From Excel - Error In XLS File In Row 0

Feb 3, 2014

I have an access database that has been written by someone else (I am a novice when comes to access!) and to which I have been asked to regularly upload data from excel.

There is a Macro written to load data from spreadsheets, and generally this works without problems. However there are a few spreadsheets which come up that result in a message box saying "Error in [name of spreadsheet] xls file in row 0" - I have checked for errors and null values in the spreadsheet but have seen this before as it generally tells me the error is in row 245 for example, but have never seen this error in row 0 before!

View 5 Replies View Related

General :: How To Split A Database For Uploading To Sharepoint Site

Dec 14, 2012

Is there a tutorial on how to split a database so that it can be uploaded to a sharepoint site and one part of it allows updates and the other part only viewing?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved